6 Replies Latest reply: Sep 4, 2014 10:02 AM by Malek Safa RSS

    Aggregate calculation

      Hi,

       

      I am trying to build a report with Manufacturer, Quantity Sold:  Today, Week, Month and Best Week. I can easily make the report for Today, Week, Month, but I don't have any clue how to find the best weekly sales in this month?

      Eg:

       

      ManufacturerToday QtyWeek QtyMonth QtyBest Week Qty in this month
      HP52010028
      Canon83017047

       

      Can anyone please suggest a solution for this?

       

      Thanks,

      Dony