Pivot Table sorting for 2 dimension

[aytacbas]

Hello community!

I have 3 dimension (CİTY, PRODUCT_GROUP, YEAR)  and 1 measure (AMOUNT) pivot table,

first dimension CİTY and second one is PRODUCT_GROUP, horizontally,  is the YEAR dimension.

I want to sort by first and second dimension separately, each dimension should be sorted in order from largest to smallest.

is that possible default Pivot chart in Qlik Sense

Qvf document is  attached and screenshot is below of the page 

Thank you very much!

[Chanty4u · Accepted solution]

Hi,

Have a look on below thread you might get some help

https://community.qlik.com/t5/App-Development/Sorting-2nd-dimension-Issue/td-p/1558354

[aytacbas]

Hi Chanty4u;

It work 🙂 but  I've never seen such a solution before

For 2nd dimension Data field area 

=Aggr(Dual(Dim2, RowNo(TOTAL)), Dim1, Dim2)

Dim2 Sorting area 

=sum(value)

thanks your help!