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
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.
Could you share the workflow so that I can see the configurations you used?
User | Count |
---|---|
107 | |
85 | |
76 | |
54 | |
40 |