You can show or hide specific items in the row and column fields, and
you can show a specific number of top or bottom records.

Do you remember how you filtered the records in Excel 97?

Andrew_SE13 wrote:
I don't seem to be able to autofilter results in a PIVOT table (eg to show
exceptions, say non zeros). I certainly could do this in Office97 (and I
think in other Office versions in between). Do I have some setting turned
on/off that shouldn't be, or has this functionality been discontinued for
some reason.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html