Previous Topic Next Topic

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 Moderator 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

Answer 1 / 2
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
Answer 2 / 2
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator 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
0

Similar discussions

Call barring cancel code
Abubakkar -
dwebb -

1 response
Reset call barring
niettieham -
Ambucias -

1 response
Remove call barring
Adelice -
HelpiOS -

1 response
Ig stories from close friends to public
Darren -
zara -

31 responses
How to undo "remove link" in bio?
mary22 -
Gourav -

13 responses