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

RadGrid Grouping with Calculated SubTotals

1 Answer 276 Views
Grid
This is a migrated thread and some comments may be shown as answers.
rajkishore
Top achievements
Rank 1
rajkishore asked on 17 Oct 2012, 10:32 AM
Hi,
I am retrieving a set of records from database and binding it to a RadGrid. I have applied Grouping to all the columns. When i am dragging a Column to group area it is making a group by the result set with respect to that column. In group footer it is displaying the Aggregate value (say Sum). Some of these column group totals are depends upon the other column total. For example My RadGrid has 4 columns.
Column 1: Product Name
Column 2: Quantity
Column 3: Price
Column 4: Percentage

The for Column 2 and Column 3 "Aggregate=Sum".
When I will drag the Column 1 the grid automatically groups the data as per product name and the group total is displaying for column 2 and column 3. 

For Column 4 Subtotal I have a Formula like (Sum(Column 2) / Sum(Column 3) ) *100.

How I can the Column 4 Subtotal for group level?
Please help.


Thanks 
Raj

1 Answer, 1 is accepted

Sort by
0
Angel Petrov
Telerik team
answered on 19 Oct 2012, 02:16 PM
Hi Raj,

I am sorry to say that with the current implementation of the RadGrid this functionality could not be achieved. RadGrid operates on a data level and thus operations like summing and counting are executed only on fields from the data source.

Regards,
Angel Petrov
the Telerik team
If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to their blog feed now.
Tags
Grid
Asked by
rajkishore
Top achievements
Rank 1
Answers by
Angel Petrov
Telerik team
Share this question
or