Question on Horizontal Multiple Fields Addition

msyosd

Could someone advise me on adding male consumption and female consumption horizontally (Please see the attached sample data below)? It's easy to do so with Excel, but I am now sure how to do it with Alteryx.
Thank you in advance for your attention and advice!

SampleData.xlsx

OllieClarke

Hi @msyosd 

You could of course do this in a formula tool with 6 formulae e.g. [0~4]+[0~4_2] etc.
but this was a slightly more dynamic approach:

There was a bit of manual intervention to align age ranges etc. so it might be simpler to go with the formula approach mentioned above

Anyway, hope that helps,

Ollie

adding horizontally.yxzp