Multi Level Pivot Table Average vs. Sum

DStayman

New Member
Joined
Apr 21, 2011
Messages
11
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.


MrExcelCurrent.JPG


MrExcelFuture.JPG
 

Some videos you may like

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.

Watch MrExcel Video

Forum statistics

Threads
1,099,113
Messages
5,466,749
Members
406,495
Latest member
Arlind Elezi

This Week's Hot Topics

Top