We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
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
binuacs
21 - Polaris

@binsell one way of doing this

image.png

binsell
8 - Asteroid

Amazing - thank you so much @binuacs 

Labels
Top Solution Authors