6 Replies Latest reply: Feb 14, 2013 11:58 PM by raj sharma

# Sales growth for 24 month back

Hi,

How can i calculate the 24 month back sales growth. Attach is a sample and i have to create a line chart for rolling 24 month back.

Let me know if any thing requires.

Thanks

• ###### Re: Sales growth for 24 month back

I tried this ... I hope it helps

Alexandros

• ###### Re: Sales growth for 24 month back

Hi,

Thanks but i need rolling 24 months.

Thanks

Ritul

• ###### Re: Sales growth for 24 month back

Hi All,

Any one help me for this.

Regards,

Ritul

• ###### Re: Sales growth for 24 month back

hiii

try this

• ###### Re: Sales growth for 24 month back

Or if you have a Date field in your data you can use that to create a new Year-Month field which you can use as your dimension. To do this you can use this in your script:

date(monthstart(DATEFIELD), 'YYYY-MMM') AS YearMonth,

That is how I would do it

If you have a month and year field you can also solve it with a calculated dimension.

The expersion is in the attached example.

Good Luck,

Dennis.

• ###### Re: Sales growth for 24 month back

Hi,

Thanks but i want to get growth by previous year like

Ex1:-

2012-12 / 2011-12

(2824 / 2531) -1  = 12%

Ex2:-

2012-11 / 2011-11

(3147 / 3048) -1  = 3%

like ways for other months upto rolling 24 months.

And i have month year field also in different table but dont know how to calculate the growth of current month vs previous year month upto rolling 24 months.

Regards,

Ritul