2 Replies Latest reply: May 12, 2011 3:51 AM by Jairish Ramsanjhal RSS

    Percentage over two dimensions in a pivot table

    Jairish Ramsanjhal

      Dear users,

       

      I would like to know if it's possible to calculate a % of the total of one dimension when 2 dimensions are defined in Qlikview.

       

      I have one dimension which is called 'Prodline' (lowest level) and the other 'Category' (highest level). In the image you can see that I have calculated a percentage of the client total over the dimension 'Category'. The 10% of '1e lijn' for 'Category' abc is based on the formula "(Sum (count_session))/(sum( TOTAL  count_session))" which is now 28 (1e lijn)/283 (total) = 10% where I would like to base this on 28/69(Total of 1e lijn). How can I manage this?

       

      Please advice.

       

      Regards,


      Rishi