Summing data by specific criteria

[binsell]

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! 

[aatalai · Accepted solution]

@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 solution]

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

[aatalai]

@binsell glad I could of helped