Help Creating New Pivot Tble Layout

Hi All,

I am trying to add a new pivot table to an existing file. But, I am having trouble getting the fields set up to display my intended result.

The pivot table data is located on the tab named "sheet 9" within the attached file.

This data consists of a list of employees, with a sub list for each week under each employees name. The next column displays the value (AVG PPM), that each employee received each week.

What I am trying to accomplish -
I want to set up the pivot table to calculate the AVG PPM for all weeks combined, but ignore weeks with 0 value. Then display the 3 employees with the top 3 averages, and if possible the bottom 3 as well.

I am not too advanced with p-tables yet, so hopefully this will be something fairly easy.

oeldere - nice to hear from you again.

see attached. maybe it will help clarify. I added some manual calculation and notes

oeldere - nice to hear from you again.

see attached. maybe it will help clarify. I added some manual calculation and notes

attachment