Qlik Sense Pivot Table Rank by one measure by display another

[#1]

Hello Everyone,

I'm having a problem sorting my pivot table

In rows:

Chain Name  ( Limitation set to :Fixed number Top :5 )

Measures

Columns

Month-Year

Measures

Gross Profit $

Gross Profit %

The problem is that i need to show top 5 based on Net Sales not Gross Profit but user want to see Gross profit displayed in pivot table for top 5 Net Sales (net sales is different measure ) does anyone know how i can solve this problem ?

Thank you !

I'm using Qlik Sense (2.0.3)

[#2 · Accepted solution]

In case someone hits the same problem this is how i solved it.

AGGR(IF(Rank(sum(Net_Sales), 4)<=5,Chain Name),  Chain Name)