Display top ten items in an Office 2007 pivot table
 

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?

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?

Display top ten items in an Office 2007 pivot table
 

Thanks Andy,

I searched high and low through all of the ribbons, didn't think to look
there!!!!

Regards

JaneH

"Andy Pope" wrote:

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?