Excel 2000 - PivotTable Sort and Top 10

C

Craig Padoa

I have just purchased this Micosft published book
Accessing and Analyzing Data with Microsoft Excel. I am
currently on the Pivot Table section (Chapeter 4).

One of the statements says "On the PivotTable toolbar,
click the PivotTable menue and then Sort and Top 10".
Where do I find this as my PivotTable menu definately
does not have 'Sort and Top 10'
 
D

Debra Dalgleish

In Excel 2000, right-click on one of the field buttons, and choose Field
Settings.

Click the Advanced button, and you'll see a dialog box with the Sort and
Top 10 options.
 

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

Solution to tricky problem of showing exactly Top N rows in Pivottable 0
Add Level for Sort in PivotTable in Excel 2007 1
#N/A values when exporting PivotTable to Excel 0
Excel Pivottable Writeback 0
The PivotTable field name is not valid (error) 1
Excel 2007: Pivottable and Rank 3
Excel 2007: Create a pivot table where data is in multible sheets 12
Sorting Data in a Pivot Table 5

Top