Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot table NOT showing zero value calculations
I would like for my pivot table to NOT show the data (in the data/column
area) that sums to a zero value. I know how to show zero values and I went thru the same menu: right click, table options, uncheck for empty cells show But that doesn't do anything since there is data there it just rolls up to a zero amount. Does anyone know how to get these zero amounts to not show in the data? Any help would be greatly appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Showing Pivot Table total on Associated Pivot Chart | Excel Discussion (Misc queries) | |||
Pivot table Calculations | Excel Discussion (Misc queries) | |||
Calculations in Pivot Table. | Excel Worksheet Functions | |||
Calculations in pivot table | Excel Worksheet Functions | |||
pivot table calculations | Excel Discussion (Misc queries) |