How to perform row aggregation in Alteryx

Question

Hello,

I have a dataset where I'm trying to filter out transactions whose row sum is greater than 20 million. I want to group the transactions by Name and Date and sum the total amount. My dataset can be seen below:

I want the following output:

I will greatly appreciate your assistance

Dev73 · Answer

Hi @jkibazo try this way.

Row_Aggregation.yxmd

flying008 · Answer

Hi, @jkibazo

FYI.

jkibazo · Answer

Could you share the workflow so that I can see the configurations you used?