Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
I did this and it works thanks!