Thread: Display top ten items in an Office 2007 pivot table
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Andy Pope Andy Pope is offline
external usenet poster
  
Posts: 2,489
Default Display top ten items in an Office 2007 pivot table
Hi,

It's part of the filtering.

Click the dropdown on Row field.
Value Filters...
Top 10

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"JaneH" wrote in message
...
In previous versions of Excel there was a sort and top ten feature. Ihave
been able to sort my pivot tabel in 2007, but I cannot find the top ten.
Is
it still available in this version?

Reply With QuoteReply With Quote