ExcelBanter - Don´t show zero values in Pivot Table

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Don´t show zero values in Pivot Table (https://www.excelbanter.com/excel-discussion-misc-queries/49982-don%C2%B4t-show-zero-values-pivot-table.html)

Lina

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

CLR

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

All times are GMT +1. The time now is 04:34 AM.