How to order a pivot table by its row totals

[#1]

Hi, I'm not able to order the attached by its total column, that is, by HOTEL_NOMBRE descending CONCEPTO and MES totals (last column). Help please. Thanks

[#2 · Accepted solution]

it should work once you select to sort it by expression =SUM(IMPORTE) descending

[#3]

Incredibly I tried everything (aggr, set analysis,...) but putting =sum(IMPORTE) descending in all the dimensions, not only in HOTEL_NOMBRE.

What a silly question I made.

Thank you very much.

[#4]

Incredibly I tried everything (aggr, set analysis,...) but putting =sum(IMPORTE) descending in all the dimensions, not only in HOTEL_NOMBRE.

What a silly question I made.

Thank you very much.