Hi All, I have input in the below format. Now since this is a quarterly process, My headers will keep changing according to months in the quarter as shown below. Input for Q1 MarAprMay200300400 Output required: MarAprMaySum200300400900 Now in the second quarter the headers will change as shown below. How do I do this dynamically using formula tool or any other tools available. Hope I'm clear with the requirement. Appreciate any help. Input for Q2 JunJulAug600700800

Dynamic Header

Hi All,

I have input in the below format. Now since this is a quarterly process, My headers will keep changing according to months in the quarter as shown below.

Input for Q1
Mar	Apr	May
200	300	400

Output required:

Mar	Apr	May	Sum
200	300	400	900

Now in the second quarter the headers will change as shown below. How do I do this dynamically using formula tool or any other tools available. Hope I'm clear with the requirement. Appreciate any help.

Input for Q2
Jun	Jul	Aug
600	700	800

Common Use Cases

Accepted answers

JosephSerpis

Hi @hemant86 you can still use the same concept of pivioting your data. I made some changes like using the Empid as a unique ID when I pivot and sum up the total and then eventually join the data back together.

Sum_23112021_V1.yxmd

All comments

JosephSerpis

Hi @hemant86 one approach would be to pivot your data and then sum up the values. I have attached an example of that approach.

Sum_23112021.yxmd

mbarone

You can flip the data vertically using a Transpose Tool , do your sum with a Summarize Tool , then flip it back to horizontal with a Crosstab Tool . The links are to the Tool Mastery Index , which is a great resource to learn tools. Also, in Alteryx itself, if you click the icons for the tool in the top palate, you'll see "Open Example" that you can click for each tool as well:

2021-11-23 12_39_26-Alteryx Designer x64 - New Workflow2_.png

Play around with it and let us know if you have any trouble or need further assistance.

hemant86

Thanks @JosephSerpis . Sorry I was not clear enough with my requirement. The requirement is as below

Input Q1

Empid	Mar	Apr	May
1	200	300	400
2	100	200	500
3	600	100	200

Output

Empid	Mar	Apr	May	Total
1	200	300	400	900
2	100	200	500	800
3	600	100	200	900

So the total will be calculated for each employee

Input Q2

Empid	Jun	Jul	Aug
1	200	300	400
2	100	200	500
3	600	100	200

Output

Empid	Jun	Jul	Aug	Total
1	200	300	400	900
2	100	200	500	800
3	600	100	200	900

Note: Headers are changing

Is there a way I can do this in the same workflow other than giving the user 4 different workflows for 4 quarters or radio buttons to chose the workflow?

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703