Excel 2007 Pivot table
 

Many times I wanted to sort the data by seconf field in Pivot. It does not
work for me. I put the cursor on field name and click the AZ button. I have
also tried Pivot option table, display and choose the filed list A to Z.

Is there any trick to it?

Dinesh