5 Replies Latest reply: Feb 2, 2016 9:01 PM by hk ongogo RSS

    Skip zero values in Pie Chart

      I have the following data




      I created a Pie chart and with Dimension = Team, Measure = Sum(Sales)

      and an Filter Pane with Dimension = Product


      When I select Lemon, the chart show Peter (40%) and Mark (60%) but also have a note "The data set contains negative or zero values that cannot be shown in this chart." because the value of Jason is 0.


      How can I suppress the "contains zero" note?  I try use some set express in Dimension but no luck.  Thanks