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!!