9 Replies Latest reply: Jan 16, 2015 1:13 AM by jagan mohan rao appala RSS

    Relative % in the Pivot table

    Bimala Mishra

      Hello  Qlik Experts:

      Can anyone help me to find out the relative % in a pivot table.

       

      E.g. Let's say, I have the data like this

      Category Product code Qty Value

      Men, PR01, 1, 100

      Men, PR02,4,300

      Men, PR03,5,400

      Ladies, PR05, 5, 200

      Ladies, PR06,5,300

      Ladies, PR07, 6, 500

       

      I will display it in a pivot table enabling Partial sum

       

      I would like introduce a column named %value  which is Individual Value/Total Value under that Category

       

      So it would be like

      Category Product code Qty Value %

      Men, PR01, 1, 100              100/800

      Men, PR02,4,300                 300/800

      Men, PR03,5,400                 400/800

      Total           10, 800              800/1800

      Ladies, PR05, 5, 200            200/1000

      Ladies, PR06,5,300              300/1000

      Ladies, PR07, 6, 500            500/1000

      Total                16, 1000        1000/1800    

      Grand Total     26  1800

       

      Appreciate a quick response.

       

      Kind Regards,

      Bimala