Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I hide zero rows in a pivot table with calculated items?
I am using .pivotFields.CalculatedItems.add in VBA in excel to add a
calculated item to a pivot table. A side effect of adding a calculated item seems to be that filtering in the pivot table becomes partially innefective. The use of any page, row, or column filter results in numbers that are filtered out being zeroed in the databodyarea but all the zero rows remain in the pivot table. Is there any simple way to remove/hide the zero rows from the pivot table? (Interestingly, the blank columns do disappear) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Error Trying to add Calculated Items to a pivot table | Excel Worksheet Functions | |||
Error Trying to add Calculated Items to a pivot table | Excel Discussion (Misc queries) | |||
How do I create calculated items on pivot table reports? | Excel Worksheet Functions | |||
Pivot Table: How do I hide calculated items that result in zero? | Charts and Charting in Excel | |||
Calculated Items in Pivot Table | Excel Discussion (Misc queries) |