Solved: how to rank pivot table dimension - Qlik Community

Nora104 · ‎2020-12-08

I want to rank like below:

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

Its result like below:

How can I write the formula?

Taoufiq_Zarra · ‎2020-12-08

@Nora104 you can use :

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

output:

Regards,
Taoufiq ZARRA

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

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

Taoufiq_Zarra · ‎2020-12-08

@Nora104 you can use :

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

output:

Regards,
Taoufiq ZARRA

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

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