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

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

example.yxmd