Pivot table with calculation and auto sort


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. 




0 Replies