Growth

[gautik92]

How to calculate the growth comparing the MT value?i have attached sample data

[its_anandrjs]

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

[gautik92]

How to calculate the growth??

[#4]

Growth may be like:

(sum([MT Value]) - above(sum([MT Value])))/sum([MT Value])

Hope this was helpful.

Thanks,

Singh

[its_anandrjs · Accepted solution]

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])