Help me in to the rolling 12 months

[#1]

Hello Everyone,

Please help me into the rolling 12 months. with attached excel and qvd

MY requirement is below:

i have month wise revenue data for three years, 2012, 2013 and 2014

if i select year it should show the 12 months of change (2014 revenue/2013 revenue) of selected year.

dimension is month-year

if i select month and year, for example if i select jun and 2014, it should show previous 12 months data, means from jun 2014 to july 2013

here for july 2013 the change is July 2013/July2012 value should show.

Change i cannot calculate separately. i should calculate in the expression only

Please help me to achieve this.

Big thanks in advance

[kuba_michalik]

But you don't have to expose YearMonth to the user in a listbox. Due to association it will change according to current selection in Year and Month, and you can base your set analysis on it anyway. To make it even easier, make it a sequential numeric field.

I'm attaching an example (your qvw, modified)

[#3]

Hi,

These is no logic for rolling 12 months in your qvd,

i do have master calender at my Data Model

[kuba_michalik]

I have made and additional modification to make the change-to-change comparison. Mind though, you have only 3 years in that example data, so you can't really select any date other then the newest or you'll run out of date range for the comparison.