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
Solved! Go to Solution.
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
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
Thank you 🙂 its working