How to sort the data?

[ameydiwanji]

Hi all,

I am using pivot in Qlik sense. I have sales figures for different locations for last six months. Now I want to sort the locations in descending order based on sales of latest month. Can some one help me on how to do this?

[lironbaram]

!hi

attach is an example app

basically you need to go to the dimension you want to sort

and in the dimension select sort by expression

and use expression similar to this

=Sum({<displayMonth, Month={"$(=max(Month))"}>}Sales)