ExcelBanter - Hiding 0 in Pivot Table

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

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Hiding 0 in Pivot Table (https://www.excelbanter.com/excel-programming/304896-hiding-0-pivot-table.html)

Bert[_4_]

Hiding 0 in Pivot Table

I have a pivot table, how do I hide values of 0? I don't
want this data to show up in the pivot. Most of the data
is 0.

Thanks,

BrianB

Hiding 0 in Pivot Table

Doubleclick the grey column heading and uncheck "Show items with n
data"

--
Message posted from http://www.ExcelForum.com

All times are GMT +1. The time now is 06:10 PM.