This is a migrated thread and some comments may be shown as answers.

[Solved] Group By Expressions and sum for every column

1 Answer 164 Views
Grid
This is a migrated thread and some comments may be shown as answers.
-J-
Top achievements
Rank 1
-J- asked on 25 May 2009, 07:45 AM
Can you make a grid like at Group By Expressions sample at RadControls for Asp.Net AJAX, but where every column would contain sum amount calculated from cells below it?

Grouping row          30              300
   Subrow 1             10              100
   Subrow 2             20              200

1 Answer, 1 is accepted

Sort by
0
Princy
Top achievements
Rank 2
answered on 25 May 2009, 08:53 AM
Hi,

You can refer to the following help document to understand how to add aggregations to the group expressions so that the group headers in the grid display the sum values for columns:
Performing calculations in group header

A better suggestion would be to use the GroupFooters to display the sum for each set of grouped rows as demonstrated in the demo below. You just have to set the ShowGroupFooter property to true and set the Aggregate property for each column to Sum.
Group Footers

Thanks
Princy.
Tags
Grid
Asked by
-J-
Top achievements
Rank 1
Answers by
Princy
Top achievements
Rank 2
Share this question
or