SUM column cell values in a table

[ciccio]

Hello,
a simple question:
i have a sort of dashboard page where are shown  5 tables.
Each table has a datasource , each datasoure is the collection resulting by LINQ statements.

Let say one of this tables haas 2 columns. How i can get the sum of the values of a column and put the result at the fott of that column?

COL1    COL2
a            2
b            3
              5 =====> this is what i'am asking for 

thanks

[Chris Gillies]

You add a total row directly from the context menu of the table and use an expression using the Sum aggregate function e.g. = Sum(Fields.Col2)

[ciccio]

Thank for answer.
What if i want to calculate the percentage for each row?

[Steve]

Hello Ciccio,

You can use a data scope related function for such scenario e.g. Exec(scope, expression) - executes the specified expression in the given data scope. Used mostly with aggregate expressions as a second parameter; this function allows changing of the data scope in which the expression is evaluated. Scope parameter is the name of the data scope we need to evaluate the expression against. For example the expression:

=Fields.Col2 / Exec(' Report1 ', Sum(Fields.Col2))

used in detail section will return the Col2 amount as percentage from the whole report.

Kind regards,
Steve
the Telerik team