Hi Caleb,

In order to get a summary for each company, you would need to group by that company and thus introduce another level in the hierarchy. There's no way to insert a summary into the middle of a rows collection like you have in your mockup here.

Having said that, I think it should be pretty simple to get very close to what you have here. I have attached a small sample project here with a quick attempt to get as close as possible to your mockup.

Actually, I made some decisions that don't exactly match the mockup, but which I thought were better. :)

For example, I put the summaries into the GroupByRow itself, in addition to having them at the bottom of each group. You could turn these off easily enough by removing the InGroupByRows flag from the SummaryDisplayArea property, if you like. In fact, you might want to play around with the various SummaryDisplayArea options, anyway, just to see which one(s) work best for your needs.

And here's the relevant code:

        private void ultraGrid1_InitializeLayout(object sender, InitializeLayoutEventArgs e)
        {
            var layout = e.Layout;
            var band = layout.Bands[0];
            var ov = layout.Override;
            // In order to provide a summary for each company, you need to group by the company.
            var companyColumn = band.Columns["Company"];
            layout.ViewStyleBand = ViewStyleBand.OutlookGroupBy;
            band.SortedColumns.Add(companyColumn, false, true);
            // Add a summary for column 3.
            var column3 = band.Columns["Col3"];
            band.Summaries.Add(SummaryType.Sum, column3);
            // Add a summary for column 4.
            var column4 = band.Columns["Col4"];
            band.Summaries.Add(SummaryType.Sum, column4);
            ov.SummaryDisplayArea =
                SummaryDisplayAreas.InGroupByRows | // This will give us summaries in the GroupByRow itself
                SummaryDisplayAreas.BottomFixed | // This will give us a grand total at the bottom. 
                SummaryDisplayAreas.GroupByRowsFooter // This will give us a summary under each GroupByRow
                ;
            // Make the summaries in the GroupByRow appears as cells instead of just raw text. 
            ov.GroupBySummaryDisplayStyle = GroupBySummaryDisplayStyle.SummaryCells;            
        }

InGroupByRows