ROLLING 16 Months Growth

[#1]

Hi

I want to represent Last 16 Month Rolling Growth%.

I have Sales of  Products for 3 Years.

Growth will be calculated as

for Eg. Oct 2013 Growth= (Oct 2013 Sales - Oct 2012 Sales)/Oct 2012 Sales.

I have to use Month Year as Dimension.

Thanks and Regards

[#2]

now share your qvw

[#3]

Here you GO

[#4]

hi

i want to represent 16 month growth Trend.

How can I achieve that?

Please have a look on attached file.

[#5]

hi aamir

You are Calculating Growth wrt last month but i want to calculate Growth wrt last Year Same month.

Example (Oct 2013 -Oct 2012)/Oct 2012

Thanks

[PrashantSangle]

Hi,

You can create a new variable

Year(date) as year

in script and nullify 'year' field instead of 'monthyear'.

[#7]

Here it is

[#8]

Aamir again you are calculating growth wrt last month .

This is not my requirement.

I want Growth wrt Last Year Same Month

[PrashantSangle]

Hi,

In xls data growth% is matching with your qvw if selection not made and when made selection values return 0

so

I think your struggling with nullify field.

If possible create Year , Month and Monthyear field at script level.

and you have to nullify year because while calculating data from last year you have to made it available,

this is all happening because of association.

[#10]

Thanks max

but can you give me an example with the existing Excel Attached?

[#11]

Hi,

If you have pivot table then you can use something like...

=RangeSum(sum([Sales]),-Before(sum([Sales])))/Before(sum([Sales]))

Vinay