Sales growth Current Year Sales vs Previous Year Sales with rolling 24 month

[#1]

Hi All,

Please provide me how to analysis the Sales growth of Current Year Vs Previous Year

Formula for calculation is

(Current Year -> Current Month Sales Value

                     /

Previous Year -> Previous Month Sales Value) -1

for all rows

Example:-

(Feb-2013 = 21

/

Feb-2012 = 226 )-1

is equal to -91%

like ways for other months

Regards,

Ritul

[#2]

Hi,

try to create a straight table with Months as dimension and this expression:

sum(<{Year={'2012'}>}Sales)

/

sum(<{Year={'2011'}>}Sales)

-1

and set number format of expression as percentage.

Hope this helps

Mario

[#3]

Hi,

Thanks, BUt i need rolling 24 months from Current Year and month to back Previous Year and month sales and built a line chart for this.

Please go through the attached Sample file also.

Regards,

Ritul