4 Replies Latest reply: Jan 19, 2018 2:50 AM by Andy Weir RSS

    Compare my Product rank with TOP 5 Products in a Pivot table

    vidya sagar malla

      Hi ALL,

       

      I developed a Pivot table in Qlik Sense which shows the TOP 5 Ranking Products based on their yearly sales. However, my product falls under rank 200. Is there a way to add my product along with the TOP 5 ranking products?

       

      Please find the example below for the Year 2017 :

      Actual:

      RankProductTotal Sales
      1A$100
      2B$80
      3C$75

       

      Expected:

      RankProductTotal Sales
      1A$100
      2B$80
      3C$75
      200M$10

       

       

      Thanks,

      -Vidya