I have a tricky requirement: I have to show the sum(sales) for in 2 cases;
1st case is Leading 5 months: In this i have to show the sum(sales) for last year this date forward to 5 months,
That means say today's date is 6/23/2015, my expression should be for 6/23/2014 to 11/23/2014 which is 5 months from today but last year.
2nd case is Trailing 12 months: this is just the sum(sales) for last 12 months i.e 6/23/2015 to 6/23/2014.
I tried plenty different ways but no luck on anything, i have tried like creating variables and using them in expressions and all those kinds of things in set expressions. Also keeping in mind i am not an expert at writing the set expressions.
That would be really great if you guys can help me out on this one.
