Summing data by specific criteria

Question

Hi All - I'm trying to sum my data by the number of credits on the two different SID's and split by course id (data attached with input and output). In excel I would do this as a pivot, but unsure how to do this in Alteryx. I have attached what I want my output data to look like. Any help would be much appreciated as brand new to Alteryx!

Data Set.xlsx

aatalai · Accepted Answer

@binsell use the summarsie tool use group by SID (and group by courseID -couldn't follow if this was needed or not based on desired output so you might need to play around a bit with the order of the group by) and then sum credit

binsell · Accepted Answer

Thank you, I have managed to resolve with this tool.