1 Reply Latest reply on Nov 20, 2018 3:31 PM by Patrick Van Der Hyde

    How to change the Averages as per date aggregation and also compare to previous months


      Hi All,

      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 ?