Formula that can add All previous columns

[Rafiuddin_333]

Hi All, Can anyone help me out if there is anyway to get value for all periods (Jan - April and subsequent periods too in the future) instead of adding period name every time in Formula tool

We have ALT +/= in excel which gives formula, Just curious if there is any such way to do in Alteryx?

Particulars	Jan-24	Feb-24	Mar-24	Apr-24	Grand Total
Cost	100	300	400	500

Thank you very much for your time

Rafi

[binu_acs · Accepted solution]

@Rafiuddin_333 you can use the transpose tool for this

[aatalai]

Also you can take a look at the crew macros and use the add totals too

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

l