There is no built in RANK function in a pivot table, you need to use it outside
of the table. If you only want to see largest, second largest etc you can sort
descending

Regards,

Peo Sjoblom

"A Lesner" wrote:

I want to use the rank formula in a pivot table.