You can display the top or bottom number of items in a
field.
To display a certain number of items in a field, perform
the following steps:
- Click the arrow beside a field in the DataPilot table and
a new filter window displays.
- Click Top n in the window, then
another new window displays.
- Select Only display the top n items.
- Set the number of items you want to display in Show area.
- Select Top or Bottom.
- Select one field in Using Field.
- Click OK. Only
the rows that meet the criteria are displayed.