Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Don´t show zero values in Pivot Table
Hi
I have a Pivot Table where I sum data. I wonder if ther is a way to make excel not showing posts/rows where the sum is zero? Thanks Lina |
#2
|
|||
|
|||
On the Pivot Table pop-up, click the little arrow by the words Pivot Table,
then choose Options, then check "for Empty cells, show:" and leave the little window blank...............then OK Vaya con Dios, Chuck, CABGx3 "Lina" wrote: Hi I have a Pivot Table where I sum data. I wonder if ther is a way to make excel not showing posts/rows where the sum is zero? Thanks Lina |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I show all field data in a pivot table, instead of blank | Excel Discussion (Misc queries) | |||
Pivot table, dynamic data formula | Excel Discussion (Misc queries) | |||
Do not show rows with no values in Pivot Table | Excel Discussion (Misc queries) | |||
How do I show summary totals from a pivot table on a bar chart | Charts and Charting in Excel | |||
Pivot Table - Group by Month - Show Items with no data | Excel Discussion (Misc queries) |