I have a grid with a calculated column which is not bind to the db and I would like to calculate the group total based on such column sum (unique name: column).
All example I have found are summing bind columns, how can I achieve to get the total of groups on a not bind calculated column?
<
MasterTableView
CommandItemDisplay
=
"Top"
DataKeyNames
=
"Id"
DataSourceID
=
"SqlDataSource1"
>
<
GroupByExpressions
>
<
telerik:GridGroupByExpression
>
<
GroupByFields
>
<
telerik:GridGroupByField
FieldName
=
"Stgroup"
/>
</
GroupByFields
>
<
SelectFields
>
<
telerik:GridGroupByField
FieldName
=
"Stgroup"
/>
</
SelectFields
>
</
telerik:GridGroupByExpression
>
</
GroupByExpressions
>
<
Columns
>
<
telerik:GridEditCommandColumn
ButtonType
=
"ImageButton"
>
<
HeaderStyle
Width
=
"30px"
/>
</
telerik:GridEditCommandColumn
>
<
telerik:GridBoundColumn
DataField
=
"Id"
DataType
=
"System.Int32"
FilterControlAltText
=
"Filter Id column"
HeaderText
=
"Id"
SortExpression
=
"Id"
UniqueName
=
"Id"
ReadOnly
=
"True"
>
<
ColumnValidationSettings
>
<
ModelErrorMessage
Text
=
""
/>
</
ColumnValidationSettings
>
<
HeaderStyle
Width
=
"45px"
/>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"Code"
DataType
=
"System.Double"
FilterControlAltText
=
"Filter Code column"
HeaderText
=
"Code"
SortExpression
=
"Code"
UniqueName
=
"Code"
>
<
ColumnValidationSettings
>
<
ModelErrorMessage
Text
=
""
/>
</
ColumnValidationSettings
>
<
HeaderStyle
Width
=
"65px"
/>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"Designation"
FilterControlAltText
=
"Filter Designation column"
HeaderText
=
"Designation"
SortExpression
=
"Designation"
UniqueName
=
"Designation"
>
<
ColumnValidationSettings
>
<
ModelErrorMessage
Text
=
""
/>
</
ColumnValidationSettings
>
<
HeaderStyle
Width
=
"150px"
/>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"Description"
FilterControlAltText
=
"Filter Description column"
HeaderText
=
"Description"
SortExpression
=
"Description"
UniqueName
=
"Description"
ReadOnly
=
"True"
>
<
ColumnValidationSettings
>
<
ModelErrorMessage
Text
=
""
/>
</
ColumnValidationSettings
>
<
HeaderStyle
Width
=
"150px"
/>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"Bkgroup"
FilterControlAltText
=
"Filter Bkgroup column"
HeaderText
=
"Bkgroup"
SortExpression
=
"Bkgroup"
UniqueName
=
"Bkgroup"
DataType
=
"System.Double"
>
<
ColumnValidationSettings
>
<
ModelErrorMessage
Text
=
""
/>
</
ColumnValidationSettings
>
<
HeaderStyle
Width
=
"55px"
/>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"Stgroup"
FilterControlAltText
=
"Filter Stgroup column"
HeaderText
=
"Stgroup"
SortExpression
=
"Stgroup"
UniqueName
=
"Stgroup"
DataType
=
"System.Double"
>
<
ColumnValidationSettings
>
<
ModelErrorMessage
Text
=
""
/>
</
ColumnValidationSettings
>
<
HeaderStyle
Width
=
"55px"
/>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"Type"
FilterControlAltText
=
"Filter Type column"
HeaderText
=
"Type"
SortExpression
=
"Type"
UniqueName
=
"Type"
>
<
ColumnValidationSettings
>
<
ModelErrorMessage
Text
=
""
/>
</
ColumnValidationSettings
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"Standard"
FilterControlAltText
=
"Filter Standard column"
HeaderText
=
"Standard"
SortExpression
=
"Standard"
UniqueName
=
"Standard"
>
<
ColumnValidationSettings
>
<
ModelErrorMessage
Text
=
""
/>
</
ColumnValidationSettings
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"Quantity"
FilterControlAltText
=
"Filter Quantity column"
HeaderText
=
"Quantity"
SortExpression
=
"Quantity"
UniqueName
=
"Quantity"
DataType
=
"System.Double"
>
<
ColumnValidationSettings
>
<
ModelErrorMessage
Text
=
""
/>
</
ColumnValidationSettings
>
<
HeaderStyle
Width
=
"60px"
/>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"Unit"
FilterControlAltText
=
"Filter Unit column"
HeaderText
=
"Unit"
SortExpression
=
"Unit"
UniqueName
=
"Unit"
ReadOnly
=
"True"
>
<
ColumnValidationSettings
>
<
ModelErrorMessage
Text
=
""
/>
</
ColumnValidationSettings
>
<
HeaderStyle
Width
=
"40px"
/>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"Cost"
DataType
=
"System.Double"
FilterControlAltText
=
"Filter Cost column"
HeaderText
=
"Cost BYR"
SortExpression
=
"Cost"
UniqueName
=
"Cost"
DataFormatString
=
"{0:N5}"
ReadOnly
=
"True"
>
<
ColumnValidationSettings
>
<
ModelErrorMessage
Text
=
""
/>
</
ColumnValidationSettings
>
<
HeaderStyle
HorizontalAlign
=
"Center"
Width
=
"65px"
/>
</
telerik:GridBoundColumn
>
<
telerik:GridCalculatedColumn
DataFields
=
"Quantity,Cost"
DataFormatString
=
"{0:N5}"
Expression
=
"{0}*{1}"
FilterControlAltText
=
"Filter column column"
HeaderText
=
"Tot. Cost BYR"
UniqueName
=
"column"
>
<
HeaderStyle
HorizontalAlign
=
"Center"
/>
</
telerik:GridCalculatedColumn
>
<
telerik:GridBoundColumn
DataField
=
"Note"
FilterControlAltText
=
"Filter Note column"
HeaderText
=
"Note BOM"
SortExpression
=
"Note"
UniqueName
=
"Note"
>
<
ColumnValidationSettings
>
<
ModelErrorMessage
Text
=
""
/>
</
ColumnValidationSettings
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"Note1"
FilterControlAltText
=
"Filter Note1 column"
HeaderText
=
"Note Comp."
SortExpression
=
"Note1"
UniqueName
=
"Note1"
ReadOnly
=
"True"
>
<
ColumnValidationSettings
>
<
ModelErrorMessage
Text
=
""
/>
</
ColumnValidationSettings
>
</
telerik:GridBoundColumn
>
<
telerik:GridButtonColumn
ButtonType
=
"ImageButton"
Text
=
"Delete"
CommandName
=
"Delete"
FilterControlAltText
=
"Filter column1 column"
ConfirmDialogType
=
"RadWindow"
ConfirmText
=
"Do you really want to delete this project and all its content?"
UniqueName
=
"column1"
>
<
HeaderStyle
Width
=
"30px"
/>
</
telerik:GridButtonColumn
>
</
Columns
>
All example I have found are summing bind columns, how can I achieve to get the total of groups on a not bind calculated column?