Aggregate to compare two columns

2 posts, 0 answers
  1. Derek
    Derek avatar
    119 posts
    Member since:
    Oct 2008

    Posted 06 Sep 2010 Link to this post

    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.

  2. Princy
    Princy avatar
    17421 posts
    Member since:
    Mar 2007

    Posted 07 Sep 2010 Link to this post

    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

Back to Top