Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Nora104
Partner - Creator
Partner - Creator

how to rank pivot table dimension

I want to rank like below:

2.png

But I use the formula:=aggr(rank(sum(Sales)),Code)

Its result like below:

1.png

How can I write the formula?

1 Solution

Accepted Solutions
Taoufiq_Zarra

@Nora104  you can use :

=aggr(rank(sum(Sales)),Season,Code)

 

output:

Taoufiq_Zarra_0-1607425297512.png

 

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉

View solution in original post

1 Reply
Taoufiq_Zarra

@Nora104  you can use :

=aggr(rank(sum(Sales)),Season,Code)

 

output:

Taoufiq_Zarra_0-1607425297512.png

 

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉