Pivot Table

K

kwh

I have set-up a pivot table with three field. Name, Date and Score. The
data is score for individuals over a period. The sort fields are Name and
Date. The total data is score. I am trying to pick the top five dates of
each individual and average the score associated with those dates. I am
using the Advanced Field options Top 10 feature, however the result is the
top five scores and the associated dates for the each individual. What am I
doing wrong?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Doughnut Chart linked with the slicer in the pivot table 0
Create if partial match then copy and paste data from one cell to another 1
Using an Excel Data Source as lookup? 0
Calculating Test Score Averages 6
pull out certain data 1
Sorting Multiple Tables 1
How to use/create code in MS Word to calculate age? 0
Can someone help me get started or point me in the right direction 5

Top