| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel VBA - Pivot table - Hide calc items when shows 0
Hi,
I would like to know how to write a macros that would hide a calculate item when there is "0" as the result of the calculation in th datafields. In fact the problem happens anytime I have a field in xlrowfield tha is not displaying the empty values of the datafield, but when I add calculated item, then the pivot shows 0 in the data where there was n data. And I want to hide all these ones. Tanks that would be a great help for me ... ed -- Message posted from http://www.ExcelForum.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| hide items with no data in pivot table | Excel Discussion (Misc queries) | |||
| Pivot Table: How do I hide calculated items that result in zero? | Charts and Charting in Excel | |||
| Calc on Pivot Table | Excel Worksheet Functions | |||
| Pivot Table: Hide Items Poperty | Excel Programming | |||
| Auto Hide Pivot Table Items | Excel Programming | |||
Threaded Mode
