Filtering values in a pivot table

**vsm** · 10-20-2011, 11:50 PM

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

**vsm** · 10-21-2011, 12:05 PM

Any ideas to overcome the problem?

**vsm** · 10-24-2011, 03:51 AM

Hi,

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

Regards
VSM

**VICHI** · 11-16-2011, 11:41 PM

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