I'm having a problem sorting my pivot table
Chain Name ( Limitation set to :Fixed number Top :5 )
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)