I have one requirement which I will be thankful if someone of you can advise.
I have one variable on 0CALMONTH.Its a multiple range variable.I have one one keyfigure in query which shows sales figures for the range of months I entered here.Now my user want to see one more keyfigure which shows sales figures for samemonth previous year....
Customer Month Actual Sales
ANC 201008 15MILLION
HNC 201007 20MILLION
Future report should be like this
Customer Month Actual Sales Actual Sales PY(Previous year)
ANC 201008 15MILLION 12MILLION(sales for same customer but for 200908 month)
ANC 201007 20MILLION 21MILLION(sales for same customer but for 200907 month
I will be greatful for your advices....