I have to show the report for Weekly, monthly, yearly, quarterly.
1. If End User selects Anything from monthly, respective Value for sales has to be displayed and it's average across each segments.
2. Need to create a parameter for 3, 6 and 12 months . so Average will be calculated based on the parameter User selects.
3. When User selects Say month September and year 2017, Sales for September -2017 should be displayed for each segment and if user selects 3 months Parameter, average should be 3 months average for each segment .
4. If user selects 6 months Parameter, Average should be 6 months average for each segment against September 2017 sales.
5. Similarly for Quarterly, yearly and week ranges. When User click any week range, user should see the sales for that week against 3 months, 6 months, 12 months average sales.
Can somebody please help me with this ?