How to exclude top and bottom n% in a pivot table?

[#1]

Hello,

I'm working with a pivot table and want to compare the average paid to the one excluding the top and bottom 5% of the fees paid by work phase within each State.  How do I do it?

Thanks,

Catherine

[#2]

Hi Catherine

i have just replied to a similar problem here

Erica

[#3]

Thanks, Erica. I’ll give it a try when I get a moment. I appreciate your help.