PivotTable - show top items

Re: 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






.

Relevant Pages

  • Re: VMS support but Iget this error
    ... The main point here is that the program posted here in this newsgroup is essentially for a database and database format that no longer exist. ... So the main program logic needs to be re-done because the data file is now a flat file. ... The locations of data fields, reports may also have to be re-done. ...
    (comp.lang.fortran)
  • Re: Reading Variables
    ... I've never used read to pull from a data file. ... get keyboard input). ... read var1 var2 < data.file ... and got the data fields from the first record fine. ...
    (comp.unix.shell)