Pivot Table - How to Filter on Value Fields

[emzon]

Hi,

How to filter on value fields?

I have this Pivot table and want to filter out ‘Sum of Amt’ below 100.
Is this possible without introduce a new column with SumOfCust in the data table? (It’s a very large table..)

 [SIZE=2][FONT=lucida console]
[/FONT][FONT=lucida console]   Data Table:             Pivot Table:        
                                               
    Date Cust Grp Amt       [B]Labels  Sum of Amt  [/B]
    1    C1   A    10       A                   
    1    C2   B    30         C1            90  <= filter out  
    1    C3   B   654         C4           476  
    1    C4   A   456       B                   
    2    C2   B   789         C2           819  
    2    C3   B    10         C3           664  
    3    C1   A    80                           
    3    C4   A    20       [B]Grand Total   2049             [/B]
[/FONT][/SIZE]

Regards,

 

[emzon]

Solved!

Right click on correct label and there it was, value filter..