I have a very simple pivot table.
Row Label = Procedure (lots of sub procedures within 1 procedure)
Procedure Code = Numeric Value of above.
Value/Total = Sum of sum of sub Procedure costs.
So pivot basically looks like this
Procedure – Procedure Code – Total
Fried Eggs – 100 – £100
Sausages – 101 – £ 50
Bacon – 102 – £500
Egg – 103 – £1000
How the hell can I sort by ‘Total’
The data will then be graphed, and then, I want to use a separate pivot to drill down in to the data of ‘Procedure 100’ and again sort this by value to be graphed.
Thanks
Edit – Just taken the numeric procedure code out and it has worked sorting on the total column!! Why wouldn’t it work with the procedure name & procedure numeric value ?!?!? 😈