Sales growth for 24 month back

[#1]

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

[alexandros17]

I tried this ... I hope it helps

Alexandros

[#3]

Hi,

Thanks but i need rolling 24 months.

Thanks

Ritul

[#4]

Hi All,

Any one help me for this.

Regards,

Ritul

[er_mohit]

hiii

try this

='>=' & Date(addmonths(monthstart(Max([Rollmonth and year])),-24),'MMM-YYYY') & '<=' 8 Date(addmonth(max([Rollmonth and year]),0),'MMM-YYYY')

[Anonymous]

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.

[#7]

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