How to get total amount and count

[esabay]

Hi All, 

May I ask for help in continuing the alteryx workflow I did? My goal here is to get the count and sum of the amounts per customer in this case the result would be Peter and Marge. Desired outcome below:

Thank you for the help

Customer	Amount	Count
Peter	xxx	1
Marge	xxx	1
Total	xxx	2

[sergejs_kutkovics · Accepted solution]

@esabay, Please review the attached workflow to see if it addresses your problem. I have consolidated all the filters into a single tool and included grouping by currency. I did this because I wasn't sure if you wanted to sum USD and EUR without any currency conversion.

[esabay]

Thank you o much! Really appreciate the help @sergejs_kutkovics