Pivot table with calculation and auto sort

Contributor

Hi, I am busy working on a pivot table to calculate 1st, 2nd & 3rd place with scores. But the sorting does not want to work if I add a calculated field.

 

I need to sort the data from largest to smallest and then work out the difference between the highest score and the other player's score. 

Example:

Janedb_1-1615534248441.png

 

0 Replies