Sorting Page Area Field Data in Excel 2007 Pivot Table

R

Rubble

In the old days (2003) you could right click a field, select properties, then
hit advanced and you could tell how you wanted to sort the field data in the
Page Filters of a pivot table. I can't see how to sort in Excel 2007 --

Any help would be appreciated . . .

Thank you --
 
R

Roger Govier

Hi

It seems to have been missed out.
Drag the field to a Row or Column area, click the dropdown and choose the
Sort option you want.
Then drag back to Report Filter area
 
R

Rubble

Thank you !!

Roger Govier said:
Hi

It seems to have been missed out.
Drag the field to a Row or Column area, click the dropdown and choose the
Sort option you want.
Then drag back to Report Filter area
Click to expand...
 

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 Table Data Column Sort Excel 2007 1
Pivot Table Page Field Issue (Not sorting) 2
Problem inserting calculated pivot fields into Pivot Table (2007) 1
Pivot Table criteria 2
Pivot Table Sort Order 1
Excel 2007 pivot table source table 1
Pivot Table 1
Different ways to build Pivot table 1

Top