3 Replies Latest reply on Oct 14, 2016 6:31 PM by Archie R

    Rolling month over month calculation involving multiple date fields

    Archie R

      This is sample data I have:

       

      Issue
      Open Date
      Close Date
      Cancel Date
      11/1/20162/1/2016
      21/15/20165/1/2016
      32/1/20162/28/2016
      43/1/20164/1/2016
      54/1/20166/1/2016

       

      I want to have a 6 month rolling trend as below.

       

      Month End
      Open
      CloseCancel
      Jan 20162
      Feb 201612
      Mar 20161
      Apr 201611
      May 20161
      June 20161

       

      Could you please advise how I can build this?