| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I hide zero value lines in a pivot table?
100100 CURRENCY & COIN - VAULT 37,752.50
100101 CCRRENCY & COIN - TELLER #1 11,892.59 100102 CCRRENCY & COIN - TELLER #2 14,850.55 100103 CURRENCY & COIN - TELLER #3 10,247.04 100104 CURRENCY & COIN - TELLER #4 - In the above pivot table consisting of 3 columns and 5 rows how could I automatically hide row 5 and all the other $0 value rows in my pivot table? Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| OLAP Pivot table - How to show items with no data ? | Excel Worksheet Functions | |||
| Pivot Table Grand Totals - Hide Some, Not All | Excel Discussion (Misc queries) | |||
| Pivot Table - hide blank cells | Excel Discussion (Misc queries) | |||
| Pivot table formatting | Excel Discussion (Misc queries) | |||
| Hide part of Pivot Table | Excel Worksheet Functions | |||
Threaded Mode
