Retrieving Aggrate Values to Place in Chart

[Thomas]

Currently, I have a simple RadGridView which shows a list of suppliers, part number, and purchase price. I'm grouping the information by the supplier and aggregating the purchase price so the user can see the purchase price by supplier. Is there a way to get the aggregate totals from the grid so that I can show them in a chart?

[Maya]

Hi Thomas,

You can get the Aggregate Results for a certain group using the GetAggregateResults method. For example, if you are using the Grouping event for taking the results, you may proceed as follows:

void playersGrid_Grouping(object sender, GridViewGroupingEventArgs e)

{          
this.groupView.GroupDescriptors.Add(e.GroupDescriptor);

var firstGroup = this.groupView.Groups[0] as AggregateFunctionsGroup;

var result = firstGroup.GetAggregateResults(e.GroupDescriptor.AggregateFunctions);

 
MessageBox.Show("Result of the aggregate function for the first group is: " + result[0].ToString());

}

Regards,
Maya
the Telerik team

[Thomas]

Thanks!

I do have one last question, what is the data type for this.groupView?

[Maya]

Hi Thomas,

The "groupView" is of type QueryableCollectionView. I am sending you a sample project implementing the idea of retrieving the aggregate values. 
 

Greetings,
Maya
the Telerik team

[Thomas]

That is what I thought. Thanks! It works perfectly!