Currently, I'm using the grouping headers (grid header item) as a rollup for values (double) when the data is grouped, by summing the data and manually adding it to the group header item cell.
What I'm seeing is that when the user clicks to sort the column, it is sorting the item values within the groups, but is not sorting the actual groups.
For example:
Name Team Year1 Year2 Year3
John 30 50 40
Red 20 30 10
Blue 10 20 30
Jane 100 50 70
Red 60 10 30
Blue 40 40 40
If I were to sort by Year1 Desc, I would expect Jane to be first and John to be second.
Does anyone know how to sort the groups as well as the items?
Thanks in advance.
What I'm seeing is that when the user clicks to sort the column, it is sorting the item values within the groups, but is not sorting the actual groups.
For example:
Name Team Year1 Year2 Year3
John 30 50 40
Red 20 30 10
Blue 10 20 30
Jane 100 50 70
Red 60 10 30
Blue 40 40 40
If I were to sort by Year1 Desc, I would expect Jane to be first and John to be second.
Does anyone know how to sort the groups as well as the items?
Thanks in advance.