Hello

My data is as below:

BA Name          Engagement Score

AA                         20

BB                         18

CC                         22

AA                           2

CC                          8

DD                          16

AA                         12

BB                         10

BB                          10

I need to calculate the average score of each BA e.g. AA would be 11.3, BB=12.6 etc.  Please note that Engagement Score is a calculated field.  It is an aggregation of scores from several data points to create this calculated value.  Ultimately, what I want to achieve is (total engagement score for a BA)/X where X is the total maximum score that any BA can accumulate.

Thank you.

Kym