3 Replies Latest reply on Nov 22, 2018 4:13 PM by David Atwell

    Calculated field with lower level detail

    David Atwell

      I am seeking to create a calculated field using the following data set:

         

      MonthTypeCategoryVolume
      Jan-12LowerStart of Month220
      Jan-12LowerNew20
      Jan-12LowerExits10
      Jan-12LowerEnd of Month230
      Jan-12MainStart of Month5524
      Jan-12MainNew207
      Jan-12MainExits175
      Jan-12MainEnd of Month5556

       

      The calculated fields I am trying to get is:

      The difference between Jan 12 End of Month (Main) and Jan 12 End of Month (Main).

       

      My expected result should be: 32

       

      Note: my dataset would have several months data so would expect to have to include in the formula the latest month.

       

      Any help would be appreciated.