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 |
Solved! Go to 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.
Thank you o much! Really appreciate the help @sergejs_kutkovics