How to create a line chart to show difference in sales month by month

[cena_abhishek]

I have a scenario where i have month on month sales available with me.

Month     Sales     Growth

Dec'13     40         

Jan'14      55          15

Feb'14     60           5

Mar'14     65           5

Apr'14     70            5

Now if i select a time period "YTD" on my dashboard the data fetched will be

Month     Sales     Growth

Jan'14      55          15

Feb'14     60           5

Mar'14     65           5

Apr'14     70            5

I have to calculate the growth and represent the same as line chart

[Anonymous]

Abhishek,

If you have the data and the growth, just add the expression for growth in the expressions tab

=sum(Growth)

Please, elaborate further your requirement.

Marc.

[cena_abhishek]

I don't have growth... I need to calculate it and then create a chart of growth

[Anonymous]

ok. One way to do it is: having the expression of Sales, add  another one, equals to first, and select accumulate 1 step back and select invisible. Add a third expression =expression2-expression1.

Marc.

[#5]

Hi,

Lets try this

In line chart write this in the Exppression tab.hope this will work

Sum({YTD={1}>} Growth)

[cena_abhishek]

Can you please help me with an example?