Aggregate Max Display column

[Bill]

Is there an easy way to accomplish the following for using the max function but display the column where the max value is?

Column 1    Column 2
A                100    
B                500    
C                200
                  Total:     800
                  Highest: B(500)

Thanks
 

[Dimitrina]

Hello,

I am not sure that I understand your requirement. The result for the MaxFunction will be aligned with the column the Aggregate funtions is defined for. Would you please clarify what does the "display the column" mean?

Regards,
Didie
the Telerik team

[Bill]

Thanks for your response.  Sorry for not explaining it very well.

In my example the max value from column 2 is 500.  In the footer i want to display not only the max value but also what is the value from column 1 where the max occured.  So I want to display the max value from column 2 and the corresponding value from column 1 in the footer of column 2.

[Dimitrina]

Hello,

Thank you for clarifying.

I am afraid that this would not be possible to be shown in the footer, as the AggragateResults does not contain information about the entire data item, but only about the SourceField of the AggregateFunction. 

Regards,
Didie
the Telerik team