271
Views
5
Comments
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.


DataGridSumOfGrouppedColumnValues.PNG
2017-10-31 16-30-21
erik berg

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.

UserImage.jpg
Sérgio Serrão

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


2020-11-26 09-30-54
Ricardo Valim

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

DataGridAggregate.oml
2019-09-20 06-40-44
Kosuke Ogawa

Hi erik berg , thanks for the tip.

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

UserImage.jpg
Tom Schmidt

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

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.