Hello,
I would like to calculate the month to month change and monthly year over year change in sales. I can do this with the ABOVE() function, however I'm not happy with this solution. If I select an entire year for example, the first month calculation will be off since it needs to reference the previous years values which are unavailable. Additionally, if I am comparing Jan-09 to Jan-08 the ABOVE(Sum(Sales), -12) is incorrect if some previous months have no data.
This leads me to believe that some sort of Set Analysis is necessary. I've tried numerous combinations of set analysis but can't seem to get exactly what I want.
Any help would be greatly appreciated.
Regards,
Steve
