I have a pivot table that i am trying to sort, i know sorting a pivot inst as easy as sorting a straight table and have tried to do it but can't get it to work. I guess its not possible but thought i'd ask her instead.
Basically, i have the month/year pivoted and i want to sort it by the expression descending.
so in the above i would want the 8.8 at the top of Nov 2018, I'm not interested in how the rest of the months are sorted, it just needs to be latest month.
In that case convert this into a straight table... because Pivot table groups the rows by the dimension above it. Which means all users who have the same Manger will come as a same chunk. The same is not the problem with a straight table