Hi,
I have a requirement to show Current Year vs Previous Year Sales for Month drill down to date. Could any of you please help me to resolve the issue. I was able to get Month Level Current Year vs Previous Year Sales by using the below set expression.
Sum({<Year = {$(=Max(Year))}>}Sales) --> Current Year Expression.
Sum({<Year = {$(=Max(Year)-1)}>}Sales) --> Previous Year Expression.
But when I drill down to date level I am seeing both current year and previous year dates. But in my case it should not show me previous year dates. Only based on Current Year, Month Dates it should show Current Year Sales on that day and Previous Year Sales on that particular day.
Can any one please help me to resolve this issue.
Thanks & Regards,
Vineeth