I want to do a report where i want to show the sales made during the last 3 years given a particular month and year. this will month - year will change dynamically. presently if i have to do that report, i create separate metrics for each year month (say user wants compare last 2 years i create three metrics aug2000, aug2001, aug2002) combination. i was told that once can use transformation for such a report but didn't have much success with that. i also checked up vmall project but couldn't understand much about transformation. can anyone give some idea on how to accomplish this without creating sales amount metric for each year/month.
thanks for your replies