Display the SUM of Attendees, where Session ID appears multiple times

Comments

2 comments

  • Avatar
    Michael Becker

    Hi Troy,

    a bit more details could be helpful. But in general if use Pivot table, and in rows put session ID, then in Values you put either COUNT of user_id, or sum of attendee count (I don't know how that information is stored in your datbase), you should get what you need. Again if you could post more details on how your data looks like, that would allow to answer more preciesly.

    Regards,

    Michał

    0
    Comment actions Permalink
  • Avatar
    Andrew Block

    Troy,

    To Michael's point the more detail the better about the table. But if all of this data is in one fact table you could just use the SessionID as a row and then use SUM(AttendeeCount) as the Value it should give you the desired result. 

    0
    Comment actions Permalink

Please sign in to leave a comment.