Pivot table hidding zeros in sum of amount
 

Hi

From the pivot table below are there any way of hiding
the lines with the zeros in the total column.

Sum of Amount
Ap/Ar ID Product Total
152344 RFUOS 0.00
RFUUK -1,150.00
13632 RPPUK -702.50
15881 RFPUK -4,207.50
16631 RFPUK 0.00
18623 RPPUK 502.00
Grand Total -5,558.00


Thus the above table appearing as below,

Sum of Amount
Ap/Ar ID Product Total
152344 RFUUK -1,150.00
13632 RPPUK -702.50
15881 RFPUK -4,207.50
18623 RPPUK 502.00
Grand Total -5,558.00



Thanks.