Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
250
Help Grouping and Summarizing in WinGrid
posted
Company ID Col1 Col2 Col3 Col4
Comp1 CC1C 90000 ASDF1 15 2
ASDF2 10 1
Total CC1C     25 3
Grand Total sum sum

I have pasted this table here to show a loose example of what I'm trying to do. I'm new to Grouping/Summarizing with Infragistics and need some tips.

In the case above there are 2 rows for Comp1 in the accompanying DataTable. The ID and Col1 values are the same for both of these rows. Then they have different values for Col2 as can be seen.

There is a "Total" at the bottom of every row in this Grid that sums Col3 and Col4. Then a Grand Total at the bottom of the Grid that sums these columns for every row.

There could be any number of rows for every Company. There were just 2 in this example. There can even be only 1 but the total will still display.

Any ideas how I should approach this problem?

I've tried adding the Company column to SortedColumns but end up with headers above every row rather than just at the top and I want the Company cells to merge together like is seen with "Comp1" above.

Is what I'm looking for possible? Or something close at least?