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