0 Replies Latest reply: Dec 18, 2017 7:08 PM by Daniel Gorman RSS

    Sum total where date is less than 12 months from today

    Daniel Gorman

      First post..

       

      Well I've a bunch of data where I need to find the total over the last 12 months from today's date.

       

      e.g.

      PartSupplierLatest DateTotalOrders Last 12 months
      ABC123BFFF1/10/2017

      50

      18
      ABD123BCF1/28/2016500

       

      So the last column is what i'm looking to create ideally, The data is rolled up to part and latest date..

       

      any suggestions guys currently learning set expressions