Pivot

  • Thread starter Thread starter Ian
  • Start date Start date
I

Ian

I have a pivot linked to a query with name of the client
in the row items and sum of sales in the data items. It
is sorted by sales. I'd like to show only the top and
bottom 20 people. Is there a way to do it in the pivot?
 
Sorry - to simple - I've got dynamic data so it's
constantly refreshing. This means I'd have to choose the
ones I want to show everytime it refreshes. I need it to
just show the Top n(%) like in a query.
 
In the Pivot Table, double-click on the Client field button
Click the Advanced button
For 'Top 10 AutoShow', select On
For 'Show', select Top or Bottom, then set the number of items
Click OK, click OK
 
Back
Top