9 Replies Latest reply: Sep 13, 2016 8:14 PM by Avishek Singh RSS

    how to get the cumulative bucket expression of a pivot to a dimension to form new pivot?

    Avishek Singh

      Hello,

       

      I am working on a sales qlikview DB project. the  ask is to transform the below pivot chart(chart 1 ) (note- last 3 columns are derived using expressions) in a way so that last column ('bucket') becomes the dimension and other adjacent columns gets computed (like in chart 2).

       

      chart 1     

      PARTNER_IDSales( PERFORMANCE)% of Contribution to total sales% Cumulative Contribution Bucket- based on cumulative contirbution
      189151381.14457817%17%TOP 20%
      290131074.37291214%31%TOP 40%
      23580938.325169112%43%TOP 50%
      8456865.396533211%54%TOP 60%
      8760707.41271039%63%TOP 70%
      18200452.488816%68%TOP 70%
      14795437.435736%74%TOP 80%
      19142433.18497025%79%TOP 80%
      8972374.081775%84%TOP 90%
      8633370.713255%89%TOP 90%
      28683201.444383%91%TOP 100%
      5423201.105813%94%TOP 100%
      19349128.407932%95%TOP 100%
      19818126.80099352%97%TOP 100%
      863186.350971%98%TOP 100%
      878430.312930%99%TOP 100%

       

        Chart 2

      Percentage# PartnersSell thru
      Top 10%0$0
      Top 20%1$1,381
      Top 30%0$1
      Top 40%1$1,074
      Top 50%1$938
      Top 60%1$865
      Top 70%2$1,159
      Top 80%2$870
      Top 90%2$752
      Top 100%6$572

       

      any kind help/advice would be appreciated.

       

      Thanks!

      Avi