My team is using a RadGrid for a dataset that returns multiple columns of numbers, and there are some calculated colums to return the % of total for each column. The calculated expressions are working properly in the row, but I'd like to get the total percentage. None of the aggregate functions work; I don't want a total of the percentages, I want the same calculation done on the total values as is being done on each row. See the screenshot for a better explanation; I'd like summary percentages where each of the arrows are.
Is there any way to accomplish this without some complicated coding in the OnCustomAggregate event? It seems like a pretty straightforward requirement.
Is there any way to accomplish this without some complicated coding in the OnCustomAggregate event? It seems like a pretty straightforward requirement.
1 Answer, 1 is accepted
0
Princy
Top achievements
Rank 2
Rank 2
answered on 07 Sep 2010, 07:03 AM
Hello Derek,
To achieve this functionality access the GridFooterItem for the corresponding column in ItemDataBound event. Then compute the necessary calculation and assign the result to the footeritem of corresponding GridCalculatedColumn by using its ColumnUniqueName.
The following documentation will help you to accessing the grid footer cell.
Accessing cells and rows
Thanks,
Princy.
To achieve this functionality access the GridFooterItem for the corresponding column in ItemDataBound event. Then compute the necessary calculation and assign the result to the footeritem of corresponding GridCalculatedColumn by using its ColumnUniqueName.
The following documentation will help you to accessing the grid footer cell.
Accessing cells and rows
Thanks,
Princy.