| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table - Hiding Zero Values
How do I ensure that in a Pivot Table Review lines with zero values do not
appear ? I have tried usung the Table Options : For Error Values / For Empty Cells options but this doesnt work . This just allows you to replace errors or blanks with an alternative value . I want to remove blanks / lines that contain zeros for every measure completely from that report . |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot Table - Hiding Zero Values
Hi - did you get an answer to your question? I am having the same issue.
"lcrean" wrote: How do I ensure that in a Pivot Table Review lines with zero values do not appear ? I have tried usung the Table Options : For Error Values / For Empty Cells options but this doesnt work . This just allows you to replace errors or blanks with an alternative value . I want to remove blanks / lines that contain zeros for every measure completely from that report . |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot Table - Hiding Zero Values
see response to your later posting
-- Regards Roger Govier "Taveras" wrote in message ... Hi - did you get an answer to your question? I am having the same issue. "lcrean" wrote: How do I ensure that in a Pivot Table Review lines with zero values do not appear ? I have tried usung the Table Options : For Error Values / For Empty Cells options but this doesnt work . This just allows you to replace errors or blanks with an alternative value . I want to remove blanks / lines that contain zeros for every measure completely from that report . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hiding blank cells within a Pivot Table | Excel Worksheet Functions | |||
| hiding zero values in a pivot | Excel Discussion (Misc queries) | |||
| Pivot Table hiding row removes from row ! | Excel Discussion (Misc queries) | |||
| PIVOT TABLE - hiding records with CALCULATED item values equal to | Excel Discussion (Misc queries) | |||
| Hiding one subtotal in a pivot table | Excel Discussion (Misc queries) | |||
Linear Mode
