http://www.contextures.com/xlPivot05.html#TopItems

I use the data file from the above site.

I drag "name" to the row fields area and "score" to the data items area. Then I double-click on name and select top 5 scores. I can even sort in ascending order of scores. No problem.

However, if I just drag score to the row fields area and nothing else, when I click on advanced, "Top 10 AutoShow" is greyed out. The way to get around this is to also drag score to the data area i.e. two identical columns of score side by side. Then I can choose the top items.

My interpretation is that we can only show top items on data fields and they must be in the data area.

Any comments?

Epinn