Sorting in Pivot Table

I am working in Excel 2010 and I created a pivot table that had Physician Name and Procedure Description as the two Row Labels and then summed up Paid Amount in the Value area. Doing this I was able to sort the Paid Amounts within each unique Physician Name from largest to smallest by simply right clicking in the Value column of my pivot and choosing sort then choosing Sort Largest to Smallest. No problems so far.

THEN, I brought in one more Row Label, Procedure Code, and now I can't sort the Paid Amounts like I was just able to a second ago.

A couple things I noticed:

1) Procedure code is a number and it is automatically sorting this field
2) Physician Name and Procedure Code are both in bold font and the Procedure Description is not bold.

Not sure if either of these two things I noticed is preventing me from sorting the dollar amounts in my Value area. Does anyonw know why this is happening? Why can't I sort the Paid Amounts any more?

Thanks!!

Originally Posted by Andy Pope

Do you not need to sort the data twice now.
Select the first item at Name level and sort then first item at code level and sort.

It would probably make things a lot easier if you could post an example that clearly shows the incorrec sorting

Here is an example of what I am trying to say:

Sum of Paid to Use
Ordering Physician Specialty Procedure Codes.Procedure Code Procedure Codes.Procedure Description Total
OBSTETRICS/GYNECOLOGY 82105 ALPHA-FETOPROTEIN,SERUM $5,629
82106 ALPHA-FETOPROTEIN - AMNIOTIC $120
82677 ESTRIOL $1,110
83080 B-HEXOSAMINIDAS, EACH ASSAY $75
83891 MOLECULAR DIAG - ISOLATE OR EXTRACT $870
83892 MOLECULAR DIAG-ENZYMATIC DIGESTION, $13,773
83893 MOLECULAR DIAG - DOT/SLOT BLOT PROD $246
83894 MOLECULAR DIAGNOSTICS, SEPARATION B $875

As you can see, I need to sum the Total column largest to smallest, but I can't. This is all within a live Pivot. It is not a regular table, in which case I would not have any problem. I am above average in Excel knowledge, but I can;t seem to figure this one out.

Thanks!!