Hide the entire column if it's grand total having value zero using wijmo

Hide the entire column if it's grand total having value zero using wijmo

Posted by: mailtovashist02 on 27 June 2022, 10:22 pm EST

• 

  mailtovashist02

  • Post Options:
  • Link
    Copy

  Posted 27 June 2022, 10:22 pm EST

  How do I hide the entire column if it’s grand total having value zero using wijmo grid angular?
  
  I have pivot grid where I want to hide the entire column if the grand total of that column is zero.
  
  Please suggest

• 

  sonu.pandey

  

  • Post Options:
  • Link
    Copy

  Posted 28 June 2022, 8:44 pm EST

  Hello,

  You may handle the loadedRows event of PivotGrid, check each column’s aggregate value in columnCollection, and update the visible property of the columns accordingly. Please refer to the sample link below demonstrating the same:

  https://stackblitz.com/edit/angular-pagnyj?file=src%2Fapp%2Fapp.component.html,src%2Fapp%2Fapp.component.ts

  Regards