I want to use the rank formula in a pivot table.
P Peo Sjoblom Dec 2, 2004 #3 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
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
