We are designing a report where we would like the data to be reported on different moving month options.
A dropdown would be placed on the report where the customer will select either a 1 month, 3 month, 6 month or 12 month Moving Total.
For example when the customer chooses 1 month (assuming report run during August 2008), the result appears as below:
Month Product count Market Count
July 2008 35 12
When the customer chooses 3 month the results appears as below:
Month Product Count Market Count
May 2008 45 8
June 2008 44 15
July 2008 35 12
In the examples above there would be 2 independent dates to do the counting namely Product date and Market date which exist in a dimension. We would somehow need to compare Product and Market date against the request moving month(s) and achieve the counts.
What is the best approach from a Framework Manager and Report Studio standpoint to achieve this type of report with the capability of doing counts at varying moving month periods?
Thank you..