How to remove 0s from excel pivot (2010)

Closed
DG83
Posts
38
Registration date
Monday January 2, 2012
Status
Member
Last seen
April 21, 2018
- Apr 30, 2013 at 10:14 AM
TrowaD
Posts
2886
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 27, 2022
- May 28, 2013 at 09:23 AM
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

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

May 27, 2013 at 07:39 AM
any ideas please? i suspect it cant be done but would like to have it confirmed
0
TrowaD
Posts
2886
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 27, 2022
515
May 28, 2013 at 09:23 AM
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
0