Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How to calculate the growth comparing the MT value?i have attached sample data
There is different formula for this may be your side is different but you can use
( sum([MT Value]) - (sum(Previos Quarter value [MT Value])))
/
sum(TOTAL [MT Value])
In the above chart you have 1 dimension and 2 expression used with Combo chart.
Dimension:- Year&'-'&Quarter
Expression:- Sum(MT Value) //This is in Bar
Expression:- Sum( GrowthExpressionHere) //Any calculated formula for Growth calculation and this is are in line graph.
Regards
Anand
How to calculate the growth??
Growth may be like:
(sum([MT Value]) - above(sum([MT Value])))/sum([MT Value])
Hope this was helpful.
Thanks,
Singh
There is different formula for this may be your side is different but you can use
( sum([MT Value]) - (sum(Previos Quarter value [MT Value])))
/
sum(TOTAL [MT Value])