1 Reply Latest reply: Oct 29, 2015 11:44 AM by Tigran Novosartov RSS

    Qlik Sense Pivot Table Rank by one measure by display another

      Hello Everyone,

      I'm having a problem sorting my pivot table


      In rows:

      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)