How to get total amount and count

Question

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

CustomerAmountCountPeterxxx1Margexxx1Totalxxx2

3PP SPREADSHEET FOR TESTING - Dummy Data.xlsx

3pp 04 March 2024 - Dummy.yxmd

sergejs_kutkovics · Accepted Answer

@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.