Using a Pivot Table to return top entries only

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
 
G

Guest

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

Pivot Table Help 1
pivot table top 60-80% 2
Showing top ten and then "others" in a pivot table 1
Selecting Fields in Pivot Table 2
Pivot Table Calculated Field - Sum/count 1
Pivot table sort 1
Creating a pivot table which resembles a SQL 'group by' 2
Pivot Table Shows Only Zeros 3

Top