create a row with average of selected rows

Hi All,

I am trying to get a new row with average of selected rows, As show in the below image I am trying to get average of UAT/QA for all the months and add as a new row called average for example 40/69*100 for Jan, 11/29*100 for Feb like this for all the months.

Thanks for the help in advance!!

Thanks

Avanti.

Data Investigation

Accepted answers

Hi @Avanthi , give this a try as well.

I hope it works for you and kindly mark this post as solution if this is what you are looking for?

Thanks.

create a row with average of selected rows-GS.yxmd

@Avanthi
Sorry about that.

Appreciate if you could mark my answer as accept if you find it useful.

1217-Avanthi.yxmd

All comments

Somethng like this?

1217-Avanthi.yxmd

Thank you, its working but I lost my sorting order on months 😞

Thanks

Avanti

Hi @Avanthi , give this a try as well.

I hope it works for you and kindly mark this post as solution if this is what you are looking for?

Thanks.

create a row with average of selected rows-GS.yxmd

For the same data set, I am trying to do prod/sum(QA,UAT) * 100 for all the months and average row should show the decimal values as well

Could you please help me on this.

Thanks.

Avanti

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703