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

    Tigran Novosartov

      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)