Sum and Group

Hi All,

May be a trivial question

I want to sum Value field and group Value 2 how can I achieve this in Alteryx. Somehow in my flow does not work.

Output

SlNo	Value	Value 2	Value3
2	6600	3500	100

Thanks

Accepted answers

You could use the summarise tool for this:

If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.

Regards,

Jonathan

Can you show the output table you're looking to achieve?

Regards,
Jonathan

Please look at update in question

You could use the summarise tool for this:

If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.

Regards,

Jonathan

I did use the summarize tool...but I had to trace back issue with 40 columns to see why the grouping was not happening 🙂

Is there any easy way to get over such grouping situations apart from removing and readding the columns in summarize tool to check ?

Thanks