Forums Retired Products and Controls
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
Close
Manuel
75
Sum columns and sum columns together with group by
posted

 Hello,

I have a Itemsource which have multiple columns. Some of them should be used for filtering and grouping, while the others should be summed up.

Example:

Col1   Col2   Col3

A         B         1

A        C          2

E         B          1


I would like to have a total sum up for Col3, which is, ungrouped 4.

If the user choose to group by Col1 the grid would be (unexpanded):

Col1   Sum of Col3

A         3

E         1


If have neither found a way to display sum's of columns nor found how I enrich the grouped by view with more information (for example row count in this group). It would also help, if it would be possible to have a total row which supports grouping, which means that if the user expands a group there would be a subtotal row.


Regards

Manuel