

Re: Calculating cumulative %
Gopal Anandan Nov 9, 2015 2:58 PM (in response to Massimo Grossi )Thanks! I was trying the same all this time but it wasn't working. I figured out that for the above to work, the first col. of the output HAS to be a Dimension (in the input data) and it can't be a dimension expression.
Earlier my first col. would be calculated dimension as Year(Period). Now with this in. the above
Sum (Qty) / Sum (total <Year> Qty) would still calculate the % against total across all years. So I even tried
Sum (Qty) / Sum (total <Yea(Period)r> Qty)  even this didn't work. Finally had to resort to change my dimension from a calculated one to a direct Year dimension and that's when the formula worked.
Is this expected behavior?


Re: Calculating cumulative %
Stefan Wühl Nov 9, 2015 2:41 PM (in response to Gopal Anandan)Create a chart with dimensions Year and Country.
Then first expression
= Sum(Qty)
and as second
= Sum(Qty) / Sum(TOTAL<Year> Qty)