Using a Pivot Table to return top entries only

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

please does anyone know if it is possible to limit a pivot table to return
only a certain number of entries.

For example, using the pivot table to sum total sales by salesperson but
then to only return the top 5 salespeople?

Thanks very much,

Dan
 
Assuming you grouped by the field called Salesperson - just double click on
Salesperson and Choose Advanced.

You can sort and choose your top 5 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

Showing top ten and then "others" in a pivot table 1
Pivot Table Help 1
pivot table top 60-80% 2
Pivot Table Calculated Field - Sum/count 1
Pivot Table and adding a % column, that is not in original data 3
Filter Excel Pivot, based on user entry form 1
Selecting Fields in Pivot Table 2
Calculating bonuses - but not a VLOOKUP or CEILING? 6

Back
Top