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!

[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

[messi007]

@msyosd,

Another way to do it.

Attached the workflow,

Regards,

[msyosd]

Indeed, I was also wondering if I should go with the tedious but straightforward approach. Thank you for the suggestion too!

[msyosd]

Thank you, very creative and helpful!