Hi Team,

I would need help in creating a formulated rank criteria in the pivot table so thats the pivot reflects the rank of the options for each team.

I have attached the example sheet to explain this better. PE List-test.xlsx

I have the raw data on "Data" tab.


Thanks,

Bonny Tycoon