DataGrid: Need help to get Sum of grouped column/Columns and printing it on the grid

I am developing a web application and using Data Grid component from Outsystems 11 version.

Need help to get the sum of grouped column value and displaying it over the grid.

Sample screen shot attached for reference.


Akash Swami wrote:

I am developing a web application and using Data Grid component from Outsystems 11 version.

Need help to get the sum of grouped column value and displaying it over the grid.

Sample screen shot attached for reference.


https://www.grapecity.com/wijmo/api/classes/wijmo_grid.flexgrid.html#groupheaderformat

https://www.grapecity.com/wijmo/docs/Topics/Grid/Aggregation/Aggregate-Group

These two properties should getting you going.

Hi erik berg , thanks for the tip.

How to set these parameters? I'm glad there is a sample.

erik berg wrote:

Akash Swami wrote:

I am developing a web application and using Data Grid component from Outsystems 11 version.

Need help to get the sum of grouped column value and displaying it over the grid.

Sample screen shot attached for reference.


https://www.grapecity.com/wijmo/api/classes/wijmo_grid.flexgrid.html#groupheaderformat

https://www.grapecity.com/wijmo/docs/Topics/Grid/Aggregation/Aggregate-Group

These two properties should getting you going.

Hi Erik,

where can we set this properties?

Tks


Hi Sérgio Serrão / Akash Swami 


You can achieve this by specifying the aggregate property on Column's AdvancedFormat.


 

In the attached sample you will find this Quantity column, and its aggregate property. Hope I could help you guys.


Regards,

Ricardo Valim

Hi Ricardo,


1. using AdvancedFormat doesnt work. I followed yours instructions, pasted 

"aggregate: 'Sum'"

there is no additional row with the SUM

2. Your file it doesn't work neither. Published, opened and


best regards