Sum Records from a column

[afvassis]

Hi - I am trying to sum a list of records and have a new record labelled "total" (this will be a new record).  It is not creating a new column, but instead adding a new record for total.  Below is an example of what I have...

Product	Revenue	Cost
A	10	2
B	15	3
C	20	4

... and I want Alteryx to add a new item "total"

Product	Revenue	Cost
A	10	2
B	15	3
C	20	4
TOTAL	45	9

Sorry for the basic question but I am still learning the tool (and loving it!)

Thanks

[AngelosPachis · Accepted solution]

Hi @afvassis.,

You have to use a summarize tool to sum the fields Revenue and Cost. Then use a union tool to bring it in the desired format.

Hope that helps 🙂

Cheers

[JosephSerpis · Accepted solution]

Hi @afvassis I mocked up a workflow that shows two way you can do this. Let me know what you think?

[meljaafari]

Hey @afvassis ,

Welcome to Alteryx 🙂

A similar workflow to the following will get you there. Of course there are multiple other ways within Alteryx to get to the same result

Attached the workflow,

Mo