How to Handle Null Values in Hierarchical Order in Pivot Grid Widget

When using the pivot widget, you may encounter a situation where a parent has no child, resulting in null values in the hierarchical order. This can be managed effectively by enabling a specific option in the Basic Settings of the pivot grid property section.

Steps to Handle Null Values

1. Navigate to the Basic Settings of the pivot grid property section.
2. Enable the ‘Hide Empty Header’ option.
   
   

By enabling the ‘Hide Empty Header’ option, the system will automatically manage the null values, providing a cleaner and more efficient data representation.