13 Replies Latest reply on Jul 12, 2018 1:39 AM by Mahfooj Khan

    Show MTD YTD with default on TODAY

    Haan Haan

      Product

      Sales (TODAY)
      MTDYTD
      Laptop2005001000
      Keyboard5006002000
      Mouse60010003000

       

      Hi all

      May I know how to come out the MTD and YTD when the view of MAX date/Today by default.

      Referring to the table. Sales show the total sales in the latest date of the data source.

      And MTD is the running sum of the sales for product that month to date. For eg, MTD, 500 means the aggregate sales for laptop during that month.

      And same goes to YTD,  the running sum of the sales for product that year to date.

       

      May I know how to do it?

      Thanks