Thank you! I have been (secretly) looking for that answer for months.
--
Mathieu


"Jim Thomlinson" wrote:

Right click on the row field that you want sorted and select field settings.
Select advanced and then alter the sort by to the data field in question.
--
HTH...

Jim Thomlinson


"Bruce" wrote:

Excel 2007

I have 3 row fields and 2 data values. I'd like to sort the list by one of
the data values, while keeping the row fields in tact.

When I look in the help section, the instructions they provide don't do
anything at all.

Please help.