HI,
I have a Pivot grid with three row groups broken down by Category (1st level), Year (2nd), and Description (3rd). I have three years (2014,2013,2012) for the Year row groups which is on the second level, but I only want to expand 2014 programmatically on the initial load, and keep 2013 and 2012 collapsed. I looked at the reference commonly sited here but I only see how that works for the first level groupings, not the second level groupings.
I thought perhaps if I did this in OnLoad:
PivotGrid1.CollapsedRowIndexes.Add(new object[] { "2014" });
it would open the only 2014 on the second level, and "force" the first level open, but that didn't work.
I also tried opening the first level in OnLoad and then expanding one item in the second level but that didn't work either.
PivotGrid1.ExpandAllRowGroups(0); //Category
PivotGrid1.CollapsedRowIndexes.Add(new object[] { "2014" });
So is there any way I can do this programmatically, or is this not supported?
I have a Pivot grid with three row groups broken down by Category (1st level), Year (2nd), and Description (3rd). I have three years (2014,2013,2012) for the Year row groups which is on the second level, but I only want to expand 2014 programmatically on the initial load, and keep 2013 and 2012 collapsed. I looked at the reference commonly sited here but I only see how that works for the first level groupings, not the second level groupings.
I thought perhaps if I did this in OnLoad:
PivotGrid1.CollapsedRowIndexes.Add(new object[] { "2014" });
it would open the only 2014 on the second level, and "force" the first level open, but that didn't work.
I also tried opening the first level in OnLoad and then expanding one item in the second level but that didn't work either.
PivotGrid1.ExpandAllRowGroups(0); //Category
PivotGrid1.CollapsedRowIndexes.Add(new object[] { "2014" });
So is there any way I can do this programmatically, or is this not supported?