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
 
Perfect! Thank you so much.
-----Original Message-----
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



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

.
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table Help! 1
Export Pivot table 1
Pivot Table question: Creating a new field that calculates thedivision of one data field by another 4
Consolidate Pivot Tables/Cache using Excel 2003 1
Pivot table report invalid 0
Pivot table from dynamic refreshed pivot table 3
Pivot Table Primer 3
Pivot grand total 1

Back
Top