You need to provide more information about the fields in your PivotTable. The
Top 10 filter (which can be anything like Top 5, Top 20) can only be applied
a single field in your Values report area.

To find the Top 20 in all of the Values report area of your PivotTable,
apply Conditional Formatting to highlight the cells.

To get rid of the "Other" data depends if it is in one field or many fields
in your PivotTable. You can use a calculated field to add them, count them
etc. and name it Other and then remove the "Other" fields from the PivotTable.

Again, without informaton about what fields and their location in a
PivotTable report area, it is difficult to answer your question completely.
--
Gnothi se auton.


"Sarah (OGI)" wrote:

Is there any way of showing the top 20 entries in a pivot table, then
grouping the remaining entries as one, i.e. 'Other'.