Skip zero values in Pie Chart

[#1]

I have the following data

Product	Team	Sales
Apple	Jason	1
Lemon	Jason	0
Lemon	Peter	2
Lemon	Mark	3

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

[#2]

Hi ,

You cannot suppress that statement.

Instead you have to modify your data select statement as >0

[sunny_talwar]

May be use this as your expression:

If(Sum(Sales) > 0, Sum(Sales))

[#4]

Sunny's expression should solve it for you

[#5 · Accepted solution]

In the Properties pane for the Pie Chart, under the "Team" dimension - set the Limitation = Exact Value and use >0

Then untick "Show others"

[#6]

This works.  Thanks

[Samrithi]

Thanks for Help All.

Really Appreciated