Creating Output with Multiple Condition and Formulas

[Vicky92]

I am new to Alteryx process. Request you to help me on my current project.

I have details of Customer name & their ID with respect to sale of product. I want to create output in the specific format listed below. For getting sales figure for each product, currently I am using SUMIF formulas in my excel file. Similarly in Alteryx I would like to create a formula so that sales figure can be generated just by putting customer name.

I have attached my input & output file for your reference. 

[atcodedog05]

Hi @Vicky92 

You can get that functionality using summarize tool.

Config:

Output:

Workflow:

Interactive lesson on Summarize tool https://community.alteryx.com/t5/Interactive-Lessons/Summarizing-Data/ta-p/424417

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[grazitti_sapna · Accepted solution]

Hi @Vicky92 

Please find the attached workflow and let me know your thoughts. I have attached the screenshot , if you find the workflow somehow or completely useful please like or accept the solution.