I have the fllw columns (description, rate, 1Q2006, 2Q2006, 3Q2006, 4Q2005, Aggregate.) in a ggc in the exact order. This is the default order of the columns in the VisibleColumns collection.
I have a drop down with the fllw values (All Quarters, 1Q2006, 2Q2006, 3Q2006, and 4Q2005)
When the user select a specific quarter, I want to hide all the other columns and show only the selected quarter.
The way I go about this is to hide all the Quarters columns (via VisibleColumns.Remove) and then add the selected Quarter back via (VisibleColumns.Add)
The problem is that when I add the the selected Quarter back, it's add after the 'Aggregate' columnn. I did not see a VisibleColumns.AddAt method. Is there a way I can easily accomplish this?