I'm very new to Alteryx and hoping someone could kindly help me. I'm trying to SUM the values in a specific column by each student and I don't want to use the summarise tool as I lose all my data. I have over 30 columns of data for each student and want to add a column to my data summing the value in the 'amount' column by 'OWNSTU + COURSECODE (DISCOUNT)'. I have attached a very slimmed down version of my data so you can see what I am trying to achieve. Hopefully this makes sense and attached the data. Thank you in advance for your help!
Solved! Go to Solution.
@binsell one way of doing this
Amazing - thank you so much @binuacs