0 Replies Latest reply: Dec 4, 2012 11:04 AM by Dinesh Thoniparambil RSS

    Simple count of rows

      I have the following data from the status logs:

       

      Assume today is Dec 4th

       

      IDDateStatus
      A12/4/2012Docs Received
      A12/3/2012Docs Sent
      A12/2/2012Docs Requested
      B12/2/2012Docs Sent
      B11/1/2012Docs Requested
      C12/4/2012Docs Requested
      D12/3/2012Docs Requested

       

       

      How can I get the counts as in below report?

       

       

      StatusAs of YesterdayAdditionsSubstractionAs of Today
      Docs Received0101
      Docs Sent2011
      Docs Requested2002

       

      Thanks,

      Dinesh.