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

How to remove zero in pivot table
How to delete part of a table in word - Guide
How to remove vibration in messenger - Guide
How to remove chat heads in messenger - Guide
Back alley table - Download - Adult games
How to undo remove link on instagram bio - Instagram Forum

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

Answer 2 / 2

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

Similar discussions

Reset call barring

Call barring cancel code

Ig stories from close friends to public

Undo remove link

Remove call barring

Similar discussions

Subscribe To Our Newsletter!