Display top ten items in an Office 2007 pivot table

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?
 
A

Andy Pope

Hi,

It's part of the filtering.

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

Cheers
Andy
 
J

JaneH

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

Pivot Tables and Filter Criteria Display 0
Doughnut Chart linked with the slicer in the pivot table 0
Showing top ten and then "others" in a pivot table 1
Slicers and Calculated Items in Pivot Table 2
how do I get a top 25 on a pivot table in excel 2007 1
selected Pivot Table filter items 0
Automatic Sorting of Top Ten values in a table 2
Backup of excel 2007 files. 8

Top