How to remove the zero row

[#1]

HI All,

I have one doc, which is attached.

This doc only includes a pivot table to show the revenue by Region.

One thing is, I want to hide the row whosw Amout is 0, how to do it?

Thanks.

[tresesco]

Several ways are there, one is like:

Re-write first exp as: If(sum(Amout)=0,0,max(SpotRate))

Then enable zero supression on presentation tab. Important to note that zero supression works when all exp columns are zero (that is what made forcefully)

[avinashelite · Accepted solution]

Hi Isaac,

Please find the attachment for the solution.

Regards,

@vi