rajkishore
Top achievements
Rank 1
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
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
0
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
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.