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

       

      ProductTeamSales
      AppleJason1
      LemonJason0
      LemonPeter2
      LemonMark3

       

      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