Dimension sum to 100% within another dimension

[kennethand]

Using this expression:

Sum( {< Periode={"2018K2"}> }weight) / Sum(TOTAL{<Periode={"2018K2"}> } weight)

I can create this bar chart (sum to 100%):

But how do show the this within another dimension? I like to show this in one graph per age-group. 

But as you can see the graph shows me the 100% distributed 'over all'. I like to see the 100% distribution within every age-group. Ex. for 30-39 years I like to see the distribution of 100%. For 40-49 yrs. I also like to see the distribution of 100% and so on.

How do I need change my expression?

[pradosh_thakur · Accepted solution]

Hi 

try the below

Let's name your dimension 1 and dimension 2

Sum( weight) / Sum(TOTAL <dimension1>  weight)

[OmarBenSalem · Accepted solution]

and u can always keep ur condition:

Sum( {< Periode={"2018K2"}> }weight) / Sum(TOTAL <dimension1> {<Periode={"2018K2"}> } weight)