Aggregate of selected rows

[j.jose]

Hallo Support-Team,

Is there any workaround/option to add only the values in a column of selected rows?

Case-Scenario
There are some rows that are already grouped and the SUM(Expenses) is shown as aggregate.
From this, the user selects / clicks on two rows only and would like to see the  SUM(Expenses) of these two rows only.
Would this be possible?

Please guide me to an example where this option is implemented.

Thanking you in advance!

Best regards,
Jiny

[paramvir]

yes it's possible to do so by defining custom aggregates.

https://paramquery.com/pro/api#method-aggregate

Selection state of a row ( when selectionModel.type = 'row' ) can be detected from pq_rowselect metadata of a row.

Code: [Select]

if( rowData.pq_rowselect ){
  //use this row in custom aggregate.
}