Pivot table via chart type - Ignore zero

RajNadar

How to ignore grand total column 'zero' value so i do not want to see zero cost value.

i do not find grand total option does not equal to "0" value in chart properties in domo

example:

Capture1.PNG

trafalger

What happens if you filter out SUM(Value) <> 0?