I have a grid which displays a list of costs - I then have a summary row which totals up the expenditure per column. I also want to display the budget values as row beneath the total and then another row which displays the difference between the actual and budgeted cost. I don't want to group my results as there is nothing really to group against but really not sure how to get a sub-total and total row
One approach would be to add 3 SummarySettings instances for the column, using a SummaryType of 'External' for the second two. Handle SummaryValueChanged and use the e.SummaryValue.SetExternalSummaryValue method to manually set the values for the last two, one for the budget values and another for the delta between actual and budgeted.