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

# Percentage over two dimensions in a pivot table

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?

Regards,

Rishi

• ###### Re: Percentage over two dimensions in a pivot table

If I understood the question, one of these.  I wasn't clear which you wanted.

sum(count_session)/sum(total <Category> count_session)
sum(count_session)/sum(total <ProdLine> count_session)

• ###### Re: Percentage over two dimensions in a pivot table

Thanks John,

That's what I meant! Thanks a lot!

Great Regards,

Rishi