Total sum or rows and columns

[sn2200]

hi,

I am trying the solve the below issue, can anyone please assist?

Current table: 

Row Labels	Jan	Feb	Mar
abc	10	5	2
abcd	1
abcde	2

Desired result:

Row Labels	Jan	Feb	Mar	Grand Total
abc	10	5	2	17
abcd	1			1
abcde	2			2
Grand Total	13	5	2	20

[ShankerV · Accepted solution]

Hi @sn2200 

This can be easily done with the help of CREWS macro.

http://www.chaosreignswithin.com/p/macros.html

https://www.youtube.com/watch?v=I45UpLqXhSY

Many thanks

Shanker V

[IraWatt · Accepted solution]

Hey @sn2200,

Here's one way of doing it with just the base tools though I would recommend just using the Macro suggested by @ShankerV. This way of doing it pivots the data so it does not matter how many month columns you have it will SUM them. This works because of the transpose which puts all the month values into one column before aggregating them:

This solution uses the transpose and cross tab tools which can be hard to understand to new users. I would recommend checking out the community Getting-Started-Learning-Path for some context on how they work: https://community.alteryx.com/t5/Learning-Paths/Getting-Started-Learning-Path/ta-p/475117#done