1 Reply Latest reply on Mar 21, 2018 9:33 PM by Dinesh Kumar S R

    Sales Report YTD QTD MTD WTD From Single Table

    theo.lopezdecastilla

      I am trying to create a report that can calculate YTD, QTD, MTD, WTD, comparing it to previous year to date.

       

      wtd.PNG

      The source dataset is an orders table with the following columns:

       

      CompletedDate
      ProductTypeCustomerType
      Quantity
      Total
      2017-05-15ItemType1CustomerType1115
      2018-01-08ItemType2CustomerType1525.00
      2017-12-28ItemType3CustomerType2321.00
      2018-02-04ItemType4CustomerType12200.00
      2017-06-20ItemType3CustomerType2749.00
      2017-03-04ItemType1CustomerType210150

       

      Is it possible to create this in one table? If yes, what dimensions or calculations are required to have prior and current running totals being compared?

       

       

       

      Thanks!