Interactive Sorting

[Solo4357]

I have created a report that has two row groups and one column group.

                   Year        | Total
Full Name | Code | Sum(Amount) | Sum(Amount)

So you can expand "full name" and get the codes under that and corresponding amounts. By default they are all collapsed. The year is the column group. So the report looks like this when you run it:

                    2006 | 2007 | 2008 | 2009 | Total
+Bob Jones |      | 25   | 50   | 50   | 60   | 185
+Jane Doe  |      | 25   | 60   | 100  | 50   | 235

Etc, etc.

I want to be able to do interactive sorting on each year. It works fine on the total but I can't seem to get the individual years to sort.

My row groups are FullName and Code. Column Group is Year.

Any ideas?