Skip to Content
0
Former Member
Nov 12, 2010 at 06:36 PM

sales from previous year

15 Views

Hi experts

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....

e.g

Todays report:

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....

Thanks alot.

Rgds.