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.
I have attached an example.
Solved! Go to Solution.
Thanks for the reply.
That's correct but its taking the Manager into consideration too. What i want is for it to just sort on Assigned User.
I have exported what you have done into excel and sorted the column there, so what i want is in the attached (i dont care about the nulls, so they can stay there)
Yes that's what i thought, i just wasn't sure if there was a way to overcome that by some fancy syntax
I will use your previous example though, and the user can drag the Manager column to the right so it appears after the Assigned User column, that will then give them the result they are looking for.
Thanks for your help
Yes, i will inform the users of the straight table option, the only issue with that is i guess as their data grows they will have more months.
Thanks very much for your help anyway, appreciated