4 Replies Latest reply: Feb 1, 2018 10:48 AM by Massimo Grossi RSS

    Top n as a % of total

    Prasad Mundewadi
      I have data like shown in below table:
      ProductOpptyValueSalesRep
      AOp1100Adam
      AOp2130Bill
      AOp3400Paul
      BOp4500Adam
      BOp5200Bill
      BOp6100Paul
      BOp7120Paul
      COp8150Adam
      COp9700Bill
      COp10220Paul
      Here Sum(value) = 2620

       

          I want to get a Pivot table like below in Qlik.

       

      ProductAs % of top 2 of total
      A530/2620--> derived as (400 + 130) since 400 and 130 are the top 2 values
      B700/2620--> derived as (500+200)
      C920/2620--> derived as (700+220)

       

      How can i do this?