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 2921 Registration date Sunday September 12, 2010 Status Contributor Last seen December 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 responses

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
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Contributor Last seen December 27, 2022 555
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