Hide numbers in Pivot table

hello!

I've got a probably very stupid question... I have a pivot table where the only data i want it to show is 2 or above... IE exclude 0s and 1s... i cannot do it! I've been staring at it for hours!

any clues?

hello!

I've got a probably very stupid question... I have a pivot table where the only data i want it to show is 2 or above... IE exclude 0s and 1s... i cannot do it! I've been staring at it for hours!

any clues?

Originally Posted by VBA Noob

Hi,

Please read rules before posting

Forum Rules !!

Could use a helper column with a formula like

=A1<2

then add it to your pivot and tick to show true's only

VBA Noob

Sorry! I'm a div - i read them after I'd been naughty

How would i add the formula to the pivot? that sounds great! I'm not allowed to send it as it's confidential info.

Originally Posted by Carim

Hi,

Why don't you use conditional formatting,
Cell Value Is Less Than 2
and pick font color white to hide cells ...

hmm, I've kind of done that, but i want the pivot to be all neat and just show me high numbers. **** or what!?
basically what i have is a tracker for employees who've been off sick... i need to track people who have had more than 1 occurrence of sickness per month...