2 Replies Latest reply on Jun 18, 2018 6:44 AM by kevin smith

    sum up only certain date parameter

    kevin smith

      Hi,

       

      Quick question. I have a data set with weekly/monthly "as of date" How do I sum up records just for the monthly date, when I drop the "as of date" on the column heading its showing a monthly trend of total records but its summing up ALL of weekly records as well. I only want to see the records at month end.

      I only want to see the numbers for 1/31,2/28,3/31,4/30,5/31, Thanks.

       

       

        

      ASOF_DATETotal Rev
      12/31/2017 00:00:001
      01/05/2018 00:00:002
      01/12/2018 00:00:003
      01/19/2018 00:00:004
      01/26/2018 00:00:005
      01/31/2018 00:00:006
      02/02/2018 00:00:007
      02/09/2018 00:00:008
      02/16/2018 00:00:009
      02/23/2018 00:00:0010
      02/28/2018 00:00:0011
      03/02/2018 00:00:0012
      03/09/2018 00:00:0013
      03/16/2018 00:00:0014
      03/23/2018 00:00:0015
      03/30/2018 00:00:0016
      03/31/2018 00:00:0017
      04/06/2018 00:00:0018
      04/13/2018 00:00:0019
      04/20/2018 00:00:0020
      04/27/2018 00:00:0021
      04/30/2018 00:00:0022
      05/04/2018 00:00:0023
      05/11/2018 00:00:0024
      05/18/2018 00:00:0025
      05/25/2018 00:00:0026
      05/31/2018 00:00:0027