I have a scoring table for work group of work items completed. Based on that they have two set of scores that are combined for a weighted score. The Pivot table Rows are set up with manager first, then associate. The scores for the associate are calculated by Calculated Field based on several Data Points in a data work sheet. My question that I'm looking to see if possible, without changing table as is, to have the average of the scores of associates in the manager line and the associate remain the same. The issue im running into here is my calculated field for the weighted score. It works for the associate level as desired however looking for average of assoc
I have included a example generated by pivot and how I would want it to generate (removed from pivot to changes names, etc. for example). Help would be appreciated.
I have included a example generated by pivot and how I would want it to generate (removed from pivot to changes names, etc. for example). Help would be appreciated.