3 Replies Latest reply on May 16, 2017 5:07 AM by matt.finn.0

    aggregate multiple date fields at row level

    matt.finn.0

      Hi,

       

      I want to sum the total number of sessions 'attended', 'cancelled' and 'did not attend' from the fields below and report which month each session took place. Here's an example of the data im working with:

       

      The result using the data above would be this:

       

      Jan 2017Feb 2017 Mar 2017
      Attended2100
      Did not attend020
      Cancelled001

       

      The difficulty is that i need to do this on row level so i can filter these totals by worker (worker id) clients (client id) and venues (venue id). For example if worker 1 was selected then the result would be:

       

       

      Jan 2017Feb 2017 Mar 2017
      Attended000
      Did not attend010
      Cancelled000

       

       

      Is this possible? Any help would be appreciated.

       

      Thanks

      Matt