Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Is there a way to hide zero subtotals in a pivot table in 2007?
Say I have CustNumb, Part, PartNum, Sum of Net Sales in my Pivot table. And say CustNumb 34567 has detail lines But his Sum of Net Sales Subtotal is zero. I don't want to see CustNumb 34567 or any other customer with a SubTotal of Zero because the file is huge and the zero subtotals just add to the confusion. thanks in advance for your help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Can i hide parts of a Pivot tables subtotals??? | Excel Discussion (Misc queries) | |||
Excel 2007 - Subtotals Below the Data in Pivot Tables | Excel Discussion (Misc queries) | |||
Hide dimensions in a pivot table in 2007 | Excel Worksheet Functions | |||
2007 Excel Pivot Tables - turn off subtotals | Excel Discussion (Misc queries) | |||
how do i only see subtotals in a pivot and hide the detail | Excel Worksheet Functions |