This content has been marked as final. Show 2 replies
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?