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

[Avanthi]

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

[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

 

 

 

[pedrodrfaria]

Hi @Avanthi,

See below for the workflows you were asking about.

Pedro.

[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

[pedrodrfaria · Accepted solution]

@Avanthi 

See attached for the workflows from the pictures below:

Pedro.

[Avanthi]

Thank you 🙂 its working