Multi Footer with Multi conditions

Multi Footer with Multi conditions

Posted by: mehmetkaya on 5 May 2023, 9:45 am EST

• 

  mehmetkaya

  • Post Options:
  • Link
    Copy

  Posted 5 May 2023, 9:45 am EST - Updated 5 May 2023, 9:50 am EST

  Hİ,
  
  I want to show total for multiple currencies separately in wijmo table

  For example

  first footer : TOTAL LEVA : 27225,41
  
  second footer: TOTAL EURO: -1,07
  
  are same wijmo table

  

  Thank you

• 

  manish.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 8 May 2023, 1:06 pm EST

  Hello,

  For this, we have to first add two more columnFooter rows to the grid. We have to then set the data in the cells of these columnFooter rows. So, we may use getAggregate() method from wijmo module and pass it the filtered data as per the category. The aggregate received by this can then be used in setCellData() method for setting values in respective columnFooters.

  Please refer to this sample for reference: https://stackblitz.com/edit/js-avj5ob

  Please refer to this sample (done with looping total categories available): https://stackblitz.com/edit/js-c3xqae

  Regards,
  
  Manish Gupta