| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
hiding zero values in a pivot
I need to suppress all zero values in my pivot table - the values are not
calculated. The reference data source, which I can't change, has about 1000 rows x 50 columns of data. I need to show one piece of it without zero's. For example, I have 150 non-zero values out of 1000 rows. Is there a way to not show zero's without manipulating the reference data source? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
hiding zero values in a pivot
I have the exact same problem. Did you ever get find a solution?
"ziak" wrote: I need to suppress all zero values in my pivot table - the values are not calculated. The reference data source, which I can't change, has about 1000 rows x 50 columns of data. I need to show one piece of it without zero's. For example, I have 150 non-zero values out of 1000 rows. Is there a way to not show zero's without manipulating the reference data source? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hiding Zero Values on Chart | Charts and Charting in Excel | |||
| PIVOT TABLE - hiding records with CALCULATED item values equal to | Excel Discussion (Misc queries) | |||
| Hiding zero values | Excel Worksheet Functions | |||
| Pivot Charts, hiding field values in second level filters? | Charts and Charting in Excel | |||
| Hiding repeated values | Excel Discussion (Misc queries) | |||
Linear Mode
