Hi Bård,

Thank you for being such an active user of the grid! Many of your questions and requests have greatly helped us to add and prioritize features in our backlog!

This being said, thank you for bringing this to discussion - we've added this to our backlog, and did some preliminary tests (the results look promising)!

We'll keep you posted on the decision to add this feature or (at least) to provide a reasonable workaround to achieve it.

Cheers,
RG

Hi,

While we don't have this option in the grid, you can achieve it by putting the following JS in the GridOnInitialize Event:

var gridObj = GridAPI.GridManager.GetGridById($parameters.WidgetId);

gridObj.provider.columnFooters.rows.push(new wijmo.grid.GroupRow());

gridObj.provider.bottomLeftCells.setCellData(0, 0, 'Σ');

Best Regards,

Daniel Figueira

Hi,

Sorry, I forgot to include that part.
Use:

gridObj .getColumns().forEach(function(column){

if(column.columnType == 'Number'){

column.provider.aggregate = 'Sum';}

});

In the IF condition you can use whatever you want. In this case, I'm showing the totals for all Number Columns but you can do it by binding for example-  column.provider.binding == 'Customer.Age'.

Best Regards,
Daniel Figueira

Hi Daniel Figueira,

Could you share the sample oml file for the same.

To the people asking for this:

Outsystems implemented this functionality with the SetColumnAggregate client action.

You just need to:

1. Set the Grid OptionalConfigs.ShowAggregateValues parameter to True. 
2. in the method: OnInitialize of the grid, you need to call the SetColumnAggegate client method, specifying the column and aggregate (SUM, AVG, ETC).

More details Component docuumentation. 

Special thanks to @Gonçalo Martins who add the link of the documentation!!!!