I want to make a chart for RONW%

[#1]

Hii All,

I am trying to make a chart in which dimension is 12 months starting from jan,feb...

an expression is formula for RONW% for each month.

and my dimension is stored in the form of:

str_fy     str_fy_month     str_fy_hy     str_fy_qtry          RONW(money_measure)

2010     jan                    H1               Q1                         value1

2010     feb                    H1               Q1                         value2

-

-

-

2011     jan                    H1               Q1                         value3

2011     feb                    H1               Q1                         value4

-

-

-

2012     jan                        H1               Q1                    value5

2012     feb                    H1                    Q1                    value6

-

-

-

where where my year is divided into halfyearly and quarterly basis,

so i want to make RoNW% chart for prior year using a variable which store the value of prior year