CAGR calculation

cmsunilkumar · ‎2015-03-03

Hi All,

I got stuck in showing CAGR values in Bar chart.

I have Year and product type as dimensions,Revenue value in $M and have to show CAGR(2011-2014) and CAGR(2014-2018).

I am trying to use bar chart here.

Could any one help to get this in Bar chart? Is this possible or is there anyother way to show these values.

Thanks

Sunil

MK_QSL · ‎2015-03-03

Can you provide some sample data or sample apps please?

vikasmahajan · ‎2015-03-03

CAGR = (pow(Column(2)/Column(9),(1/4))-1)

to calculate 4 yrs cagr col(2) will be current yr sale and col(9) with last three yrs sale

HTH

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

vikasmahajan · ‎2015-03-09

HAVE YOU GOT CAGR ?? STILL ANY CLEARIFICATION

VIKAS

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

cmsunilkumar · ‎2015-03-09

Yes....i am facing some issue.

do you want me to first add column 2 and column 9?

can you please tell me the expression to calcuate CAGR for 2013-2012 when my selection is 2014?

Related Topics