Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using a Pivot Table Calculated Field to get a Unique Count | Excel Worksheet Functions | |||
Removing errors from a Pivot table | Excel Discussion (Misc queries) | |||
Pivot Table services | Excel Discussion (Misc queries) | |||
pivot table multi line chart | Charts and Charting in Excel | |||
Problem with Pivot Table Drop-Down Menus | Excel Worksheet Functions |