Top 10 data sort in Pivot Tables

G

Guest

I have looked on Help to see how to sort the data in a pivot table, to give
the Top 10 in the right order, but when I try to follow these instructions I
do not see the options.

I can see the Pivot Tool Bar and click PivotTable but then it does not give
me the option Sort and Top 10.

I am new to Pivot Tables, can anyone help me please?
 
R

Roger Govier

Hi Gill

Double click on a Field name>Advanced>click radio button for Show Top 10.

Regards

Roger Govier
 
D

Debra Dalgleish

If you select a cell in the Row or Column area, the Sort and Top 10
option should be available. If you select a cell in the Page area, or
Data area, the option may be unavailable.
 

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

Sort in a Pivot Table 1
Pivot Table Data Column Sort Excel 2007 1
Pivot Table Soret 1
Sort top 50 in Pivot table 2
How To Obtain The Top 10% 4
Top X% in Pivot Tables 1
Pivot Tables disconnect 1
Duplicating Pivot Tables 2

Top