Alteryx Designer Desktop Discussions
Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
I have a set of sample data that I'm trying to add up by the ID column. I can use SUMIFS in Excel but my real data has many rows and I'd like to automate this step through Alteryx. I cannot use another SUM tool because I want to keep the Due Date and the sources columns. Is there a formula that can help achieve the result that SUMIFs will do and also want to keep just the first occurrence of the SUM in the result column. Please see my attached data file and the desired output, and I really appreciate your help!!! Thank you so much!!!
Solved! Go to Solution.
@EYU07 You can use the summarize tool to get the sum grouped by the ID No. Then you can use the join tool to join the sum back together to all the ID No's. The multi-row formula tool just keeps the first Grand Total and get rids of everything else. Does that help?
