hello.. i use pivot tables every day but one thing i cannot work how to do is to insert functions in a pivot table. I know how to insert calculated fields but what i really want to do is insert the RANK function into my pivot table.

I would also like this RANk function to recalculate as the pivot table is filtered and changed, etc,

Any help with this is really appreciated.

cheers

matt