View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
dan dan is offline
external usenet poster
 
Posts: 866
Default Using a Pivot Table to return top entries only

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