create row to sum values of the columns

[Camiiara]

Hi! i need to create a row at the end of the table to sum values of each column. The rows and columns are dynamic, they change every day. I already did the column with totals, but could not do the row with totals (red line).

Please see below an example of what i need to do:

House	color	2-Jan	3-Jan	4-Jan	total
a	red	50			50
b	blue	100	50		150
c	brown			25	25
d	yellow		100		100
e	pink	5	10		15
f	black				0
TOTAL		155	160	25	340

Thank you so much for the help! 

[cmcclellan]

Create a Summarize tool that sums the columns that you're after, then union back to the original file

[JamesCharnley]

HI @Camiiara 

There's actually a CReW Macro called Add Totals which can do this for you and make your life a bit easier. This will work for both columns and rows. Shoutout to @MarqueeCrew 

You can learn learn more about them and find the link to the download site here: https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/CReW-Macro-Support/ta-p/465740

[MarqueeCrew]

@JamesCharnley 

Thanks for the shout out for CReW

[Emmanuel_G]

@Camiiara 

Find attached the way of doing that for this particular case.

[ArijitRoy]

Hi Camiiara,

Please check the solution and let me know if it works.