I have a situation where a training Session ID can appear multiple times (that is acceptable in this scenario).
Each occurrence of the session may display a different Attendee count (again, acceptable).
How can I COUNT the Session ID once, yet display the Attendee count SUM for all occurrences of that session id?
session id Date Attendee Count
1 1/1/2018 23
1 1/2/2018 36
1 1/2/2018 12
I would like to display as follows:
session id Attendee Count
Please sign in to leave a comment.