This content has been marked as final. Show 3 replies
I've added some data to a pivot table, but of course it's never in the order that's needed!
The rows are text, and I can't sort them alphabetically as that isn't what its required.
Assuming the Column is [Costheader] and has values of 'Sales', 'Gross Costs' and 'Labour', what expression can I use to order them in this fashion?
Any help gratefully received!