Sorting Data in a Pivot Table

[Janet BN]

Hi, some help please.

I have a pivot table which lists job no's & tasks (exported from MSP) with
the "data" the start & finish dates. I need to sort the job's by start date.
I have tried a number of things, but not the result I want, so I checked out
Help. Help suggests the following:

On the PivotTable toolbar, click PivotTable, and then click Sort and Top 10
etc.

But for some reason the "Sort and Top 10" function is grey'd out in the
menu. Do I have to have something else turned on for this to work.

Alternatively, is there another way for the data sort to override the
Row/Column data.

Thanks in advance.

 

[Debra Dalgleish]

The Sort and Top 10 command is available for Row and Column fields.
If you want to sort by the dates in the data field, the quickest way is
to select a cell in the column that you want to sort, then click the A-Z
or Z-A button on the Excel toolbar.

 

[Janet BN]

Thanks Debra, but I'm afraid that did not work. The data didn't move at all.

Any other ideas that might help please.

Janet

 

[Debra Dalgleish]

Select the Job No field button, and on the PivotTable menu, choose
PivotTable> Sort and Top 10
Select Ascending (or Descending)
From the "Using Field" dropdown, choose Date
Click Ok

 

[Janet BN]

Thanks Debra - your a hero. It's amazing how simple the answer can be
sometimes - Doh!

Janet

 

[Debra Dalgleish]

You're welcome! Thanks for letting me know that it helped.