Here's how you can do this:
You could actually also achieve the same result without the join! As @Luke_C has done transposing the data, we could instead then crosstab it back (from row labels to column headers) but also ticking the total column in method for aggregation alongside sum (as seen below).
Ticking SUM method for aggregation:
Ticking Total Column method for aggregation:
Kind regards,
Jonathan
User | Count |
---|---|
19 | |
15 | |
13 | |
9 | |
8 |