I have a tables that needs to include X amount of rows regardless if the value is 0 or not. I need to find a way to leave values that are 0 off of the pie chart and only chart value that are greater than 0.
As I see it, my only option is to create another Stored Procedure and Data Set similar to the one that is currently used for the table but leave out the 0 value rows. I would prefer not to do this since this would mean more code to maintain when there are future changes.
Is there a way to use the data set that feeds the table and has rows that contain the 0 value or will I need to do the alternative of recreating the SP and DS's but leave out the 0 value rows.
Thanks!