Grand Total row not getting displayed properly

[Samir Modi]

 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?

[Sivamathi Natarajan]

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]

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!

[Saranya Sivan]

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.