Show / hide empty cells or rows

[M Oliveira]

Hi,

We're using your pivot tables to analyze datasets that sometime include rows or fields with no data.

Given that this is not useful and impacts the loading times, we'd like to know if the pivot tables include any option to show or hide these fields as a way to speedup rendering. Is this possible?

Thanks in advance.

[Saranya Sivan]

Hi Oliveira, 

  

By default, the pivot table only shows the field item if it has data in its row or column combination. To show all items that do not have data in row and column combination in the pivot table, use the showNoDataItems property by settings its value to true for the desired fields.  

 

Please find the UG for your reference in the below link. 

 

UG: https://ej2.syncfusion.com/react/documentation/pivotview/data-binding/#show-no-data-items 

 

  

Please let us know if you have concerns. 

  

Regards,   

Saranya S.