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
2742
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 4, 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
2742
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 4, 2021
460
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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!