How to perform row aggregation in Alteryx

[jkibazo]

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

[cjaneczko]

This should work.

Remove the Union tool if you don't want to see Null values (those under 10,000). I included them just incase you wanted to do something with them.

[jkibazo]

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

[flying008]

Hi, @jkibazo 

FYI.

[Dev73]

Hi @jkibazo try this way.