Thread: Filtering values in a pivot table

I have a pivot which gives values for an Account for two different periods in column and difference between two periods in absolute value as well as %.

Is there a way by which I can Filter the values in the pivot so that it shows only cases where the absolute value difference is more than 1,000,000 and % difference is more than say 20%

I have attached the pivot created so far.

Any help would be much appreciated.

V S Mohanakrishnan

Any ideas to overcome the problem?

Hi,

Have not seen any response for this. Is this too difficult or too easy enough. Can someone please help

Regards
VSM

Originally Posted by vsm

Hi,

Have not seen any response for this. Is this too difficult or too easy enough. Can someone please help

Regards
VSM

i see ur post is very old...i hope u may have solved this prob!!
well i am facing the same...have even started a new thread...but no reponse if u have figured out could u share it pls