Dear Alteryx Community,
I have added a column using the formula tool for Total spend (I multiplied the Average Spend by Annual visits). I am tasked to add another column called Total spend per Customer. I have a column with Customer IDs which I need to total - how do I do this? I also need to total the Total Spend. Once I have these numbers I should be able to create the Total Spend per Customer column by simply dividing total spend by the number of customers.
I just need help with how to total or add the data in a column first. Can somebody give me some advice?
Thanks again!
Hi @ldean
if I understand your challenge correctly, you can try to add a "Summarize" tool to get the Total of customers as well as Total Spend. Then you can use "Append Fields" to append these 2 fields to your main dataset.
Hope this helps. Cheers!