Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Summing a column without using the summarise tool as need to keep the data

binsell
8 - Asteroid

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! 

2 REPLIES 2
binu_acs
21 - Polaris

@binsell one way of doing this

image.png

binsell
8 - Asteroid

Amazing - thank you so much @binu_acs 

Labels
Top Solution Authors