How to order pivot table by a total field

[#1]

Hi,

I 've attached my real file to finally know if it is possible to order 'TTOO' descending by 'TOTAL W + S' -->'Prod.'

Thank you all

[Gysbert_Wassenaar]

Try not sorting HOT on Y-Value and sorting TTOO descending on =sum(I_PRODUCCION). As far as I can tell that sorts the table like you want.

[#3]

I'm sorry I should have attached an exemple with several HOT.

You are right with the exemple I attached it shows the right order, but , when there are several 'HOT' how could I get the right descending order into each HOT? maybe I have to use 'aggr' but I do not understand exactly how.

Thanks