7 Replies Latest reply: Nov 8, 2013 9:35 AM by Anna fuksa RSS

    Rankings Help

      I am trying to create rankings i.e Top 25, Top 30 based annual sales with-in variance groupings i.e products, industry, etc....

       

      However,  the trick is getting the remaining customers as cumulative sub-total within the total (see table below)

       

      RankCustomer Sales
      1a10
      2b9
      3c8
      4de7
      5fg6
      6Others10
      Total50

       

      I can create this in excel, I have created the result set within an sql if using oracle just cant get the aggregate function in Qlikview.

       

      Any help is greatly appreciated.

       

      Thanks