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?
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?