Pivot

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?
 
G

Guest

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.
 
D

Debra Dalgleish

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
 

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
Grouping daily records by week for chart display 1
Sorting pivot table by specific field (column) 1
Pivot table from dynamic refreshed pivot table 3
Consolidate Pivot Tables/Cache using Excel 2003 1
HOW TO EXTRACT (or lookup) DATA FROM A PIVOT TABLE 3

Top