Subtotals on certain fieldson Grid

Posted by: riya.katawate16 on 20 June 2022, 10:27 pm EST

  • Posted 20 June 2022, 10:27 pm EST

    Hi Team,
    I want to show subtotal only for certain fields on wijmo-Grid
    , Currently its showing subtotal for all fields.
    How can I achieve this. Please help.

    Thank you.
  • Replied 21 June 2022, 3:39 pm EST


    You may use the formatItem event of the FlexGrid and check if the instance of the row is a GroupRow(subTotal row) then remove the cell value from its innerHTML. You may refer to the code snippet below for reference:

    onFormatItem(s, e) {
    if (
    e.panel === s.cells &&
    s.rows[e.row] instanceof wjcGrid.GroupRow &&
    s.columns[e.col].binding === 'amount' &&
    s.rows[e.row] == 'Germany'
    ) {
    e.cell.innerHTML = '';

    You can also refer to the sample link below demonstrating how to remove the subtotal from the group name Germany, you can use a similar approach to implement it as per your requirement.

    Sample link:

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels