create a row with average of selected by summing up the rows

HI All,

For the given data set, I am trying to get average by doing prod/sum(Dev, FT,QA,UAT) * 100 for all the months and average row should show the decimal values and I need to calculate the average of each program for all the months like Insurance for each month / Total (Dev, FT,QA,UAT) * 100

Thanks in Advance

Thanks

Avanti

1.PNG

2.PNG

Output for dataset2.PNG

Data Investigation

Accepted answers

pedrodrfaria

@Avanthi

See attached for the workflows from the pictures below:

Pedro.

New Workflow8 (1).yxmd

All comments

BrandonB

I think that the easiest way to do this will to use a transpose tool. You will check the box for your environment column as a key column and all of the months will be transposed. You can then follow this with a summarize tool where you can group by months and then average the values. I have attached a workflow as an example

Example Average.yxmd

pedrodrfaria

Hi @Avanthi,

See below for the workflows you were asking about.

Pedro.

New Workflow8.yxmd

Avanthi

Thank you for the response

I want the average as a row like below image for environment and for program it should give average for each program for each month i.e for insurance in Jan it is 11 and total of environment it is 614 it should give 11/614* 100

Thank

Avanti

Output1.PNG

Output2.PNG

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15875

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703