How to remove 0s from excel pivot (2010)

Closed
Report
Posts
38
Registration date
Monday January 2, 2012
Status
Member
Last seen
April 21, 2018
-
Posts
2829
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 22, 2021
-
Hello,

Do you know guys how it is possible to remove zeroes from an excel pivot when the field is not in the report filter but in row label. I have several 0 items i would not like to see there.

thanks a lot

2 replies

Posts
38
Registration date
Monday January 2, 2012
Status
Member
Last seen
April 21, 2018

any ideas please? i suspect it cant be done but would like to have it confirmed
Posts
2829
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 22, 2021
490
Hi DG83,

I haven't got much experience with pivot tables, but can't you just remove the 0's from the sheet (source matrix), thus updating the pivot table?

Best regards,
Trowa