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:
