Display top ten items in an Office 2007 pivot table

  • Thread starter Thread starter JaneH
  • Start date Start date
J

JaneH

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?
 
Hi,

It's part of the filtering.

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

Cheers
Andy
 
Thanks Andy,

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

Regards

JaneH
 

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
Top Ten Albums 10
how do I get a top 25 on a pivot table in excel 2007 1
Automatic Sorting of Top Ten values in a table 2
Excel 2007 Pivot Table Sorting 1
Excel 2007 pivot table source table 1
Pivot Table - Controlling how many rows of data are displayed in t 1
Pivot table data layout - columns to rows 1

Back
Top