Subtotals on certain fieldson Grid

Subtotals on certain fieldson Grid

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

• 

  riya.katawate16

  • Post Options:
  • Link
    Copy

  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.

• 

  sonu.pandey

  

  • Post Options:
  • Link
    Copy

  Posted 21 June 2022, 3:39 pm EST

  Hello,

  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].dataItem.name == '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: https://stackblitz.com/edit/angular-xd3add?file=src%2Fapp%2Fapp.component.ts

  Regards