Help with script for Dates comparison (year over Year)

[Anonymous]

Hi All I am coming up with a strange issue.  We have introduced a new discount program which gives 15% off on the goods the customer purchased and  the customers who qualify can take the discount as many times he can . The very first date the customer takes advantage of the program we are capturing in a table called Customer_Discount_Start_Date. And we have a Sales table in which we capture the sales for the entire sales from past 3 years until today. And i Have a calendar table in which we have created some flags for doing Year over Year, YTD, last 24 months etc for using this flags in expressions. Now the users have requested to have a comparison like lets say if a customer (35790) whose first discount date is Jan-13-2014 and they want the sales from that first date to today as one expression that needs to be compared to the same year last year. How can i do that. Any ideas or help would be greatly appreciated. I have many customers like that. But for easy purpose i am loading only 2 customers in the qvw file with the attached. 

[Anonymous · Accepted solution]

i was able to get the answer. Chiru thanks a lot for your help man.

[Jason_Michaelides]

Glad you sorted it out. To best aid the community you should post the answer as other people may be looking for something similar. People have helped you - pass it on!

[Anonymous]

Hi Jason , thank you for your suggestion . Sure i will follow your suggestion. I have attached the qvw document which has he answer in it. But forgot to mention it.