How to sort pivote table in qliksense on Total column

[P_Kale]

Hi,

How we can sort Pivote table descending order on the basis of total i.e. column "C" 

File is attached for reference.

Thanks in advance.

@rwunderlich 

@marcus_sommer 

[Aunitha]

Hi @P_Kale ,

Try this, In pivot table select Sorting in  properties and enable sort by first measure option and select descending before that make sure total is your first measure.

[P_Kale]

Hi,

It is not working as Total column is coming from qliksense display total option. 

[MatheusC · Accepted solution]

@P_Kale 

Try it this way:
In the Classification tab, leave your custom expression and classify by its value.

Att, Matheus

[P_Kale]

Thanks MatheusC it is working.