sort on count and change order of columns pivottable

[Kirsten]

I have sorted  my pivottable on count but would like to have an additional sort in which I change the order of my columns: service area 1, service area 2, service area 3, service area 4 . My sorting on count already works.

I assume the sorting by columns need to be integrated in my first expression in sort?

But how to have both integrated in one expression?

See attachment

[lorenzoconforti · Accepted solution]

From what I can see, you are sorting "Material+Material Desc" by expression in descending order based on "Service Area 4" 

Now you want to sort "Service Area" based on an expression; this sorting will not be linked to the previous one as you are sorting a different dimension of the pivot table. You just need to sort "Service Area" by expression 

[Kirsten]

I did this and it works thanks!