MS Excel 2007 - Sort pivot table data 1

[BxWill]

Hopefully, someone can provide insight as to sorting pivot table data.

Using MS Excel 2007, I have a pivot table displaying Top 10 providers based on the paid amount with the following layout:

Report Filter
Market
Column Labels
Level
Row Labels
Provider
Period Month Nm ("Prior" or "Current")
Values
PaidAmt
Visits

I am displaying the grand total for the rows.

My objective is to sort the pivot table data, in descending order, by the grand total paid amount for each top 10 provider.

How do I accomplish? Have manually moved up the providers to sort but this is quite time consuming.

Thanks in advance.

 

[SkipVought]

hi.

right-click the pivot field heading.

Select Sort

Select More Options

Select Descending by and select from the Drop Down

BTW, this assumes Pivot Table Options - Display Tab > CLASSIC

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[BxWill]

Did try the suggestion and receive the "Sort by Value" dialog box
that display the following:

Sort Period_Month_Nm by Paid in descending order using values in this column: Grand total

Upon clicking "OK", the results are not sorted by the provider name which is the first row label.

Any other suggestions? Maybe, I should concatenate the provider name with the period month name in another column??

Still reviewing and appreciate any additional insight.

 

[SkipVought]

Guess I am not understanding your DATA.

Post a sample of your PT and what you expect using this example.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[BxWill]

there are two label names - Provider name and the Period Month name (Prior or Current) like displayed below.

I would like to sort by the Grand Total amount, in descending order, so that the BBC Company will display before the ABC Company. Is this possible or does the sort within the pivot only works when there is just one label name?

                         Level
                          1       2     3    4  Grand Total
ABC Company   Current     50      60    50   40 200      
              Prior       25      45    55   25 150
BBC Company   Current     100     120   110  50 380
              Prior       80      85    20   40 225

 

[SkipVought]

My result using Sort Company > More options - Sort DESCENDING by Sum of Value
[tt]

Co Prd 1 2 3 4 Grand Total
BBC Company Current 100 120 110 50 380
Prior 80 85 20 40 225
ABC Company Current 50 60 50 40 200
Prior 25 45 55 25 150
[/tt]

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[SkipVought]

BTW, I was able to use your PivotTable copy, to generate the source data, using the procedure outlined in faq68-5287.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}