View Single Post
  #2   Report Post  
Roger Govier
 
Posts: n/a
Default Top 10 data sort in Pivot Tables

Hi Gill

Double click on a Field nameAdvancedclick radio button for Show Top 10.

Regards

Roger Govier


Gill wrote:
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?