Grand Total row not getting displayed properly

Question

I a using pivot view component and the grand total row seems to be blocked by a bar as shown in the image. It also appears/disappears when i zoom in and out to test with diff screen sizes. Can you take a look and suggest a fix?

Saranya Sivan · Accepted Answer

Hi Samir, 
  
We would like to inform that the requirement can be achieved through the Value Filtering feature by setting code behind filter. Please check the below UG  and Sample link below for your reference. 
  
UG link: https://ej2.syncfusion.com/angular/documentation/pivotview/value-filtering/#value-filtering-through-code 
  
Sample Link: https://stackblitz.com/edit/angular-ypvo7b-emw8ts?file=app.component.ts 
  
Code Example: 
  




ngOnInit(): void { 
    this.dataSourceSettings = { 
      allowValueFilter: true, 
      values: [ 
        { name: "Amount", caption: "Amount" }, 
        { name: "Quantity", caption: "Quantity" } 
      ], 
      filters: [{ name: "Product", caption: "Product" }], 
      filterSettings: [    {   name: "Country",    measure: "Amount",     type: "Value",     condition: "DoesNotEquals",    value1: "0"   }   ], 
      rows: [{ name: "Country" }, { name: "Products" }], 
      formatSettings: [{ name: "Amount", format: "C0" }], 
      columns: [{ name: "Date" }], 
      dataSource: Pivot_Data, 
      expandAll: false 
    }; 
  } 
}  
  
In the screen shot below, you can see that based on the condition in the filter settings the row “United Kingdom” will be removed after applying filter. 
  
Before applying filter: 
  
  
   
  
After applying filter: 
  
  
  
  
  
  
We hope the above sample meets your requirements. Please let us know if you have concern. 
  
Regards, 
Saranya Sivan.

Sivamathi Natarajan · Answer

Hi Samir, 
 
We suspect that you have customized the pivot table component. So, kindly provide us your customized whole application in runnable state to reproduce the problem at our end which would be helpful for us to provide the solution earlier. 
 
Please let us know if you concern. 
 
Regards, 
Sivamathi.

Samir Modi · Answer

Thanks Sivamati. I think there was some css issue which is resolved now. I had a follow up ques - Can we filter rows with grant total value as 0? Can we use filterSettings object on the datasource and remove rows where grand total is 0? thanks!