With a schema of Menu, Report, User, Views to track hits on web pages I am using the GridDataControl in hopes to group by Menu and Report with aggregations rolling up ViewCounts.
The problem is that I can't seem to figure out the magical combination of steps to change the group summary to be in this format
{Name} - SUM(ViewCount) so to speak.
the default is...
{ColumnName} - {Name} - Count(ViewCount)
I tried to add an aggregation using the {Name} placeholder but I get an error.
Bottom line is the expected result should look like the following...
- DOCUMENTATION (124 Views) <-- the menu group with sum
+ Help Document (100 Views) <-- the report group with sum
+ Another Help Document (24 Views)
NOT
- Menu - DOCUMENTATION (2 items) <-- the menu group with sum
+ Report - Help Document - (5 items) <-- the report group with sum
+ Report - Another Help Document (5 items)