We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date

hide row in pivot grid


is it possible to hide a row in a pivot grid?
This row should be displayed if there are values present and should not be displayed
if there are no values present.


1 Reply

VK Vinoth Krishnamoorthy Syncfusion Team March 23, 2017 12:34 PM UTC

Hi Patrick, 
Yes, we can achieve your requirement with the help of Measure Filters. Please follow the below steps to achieve your requirement: 
Step 1:  
Open the report (i.e. .sydx file) in designer. 
Step 2: 
Move to the Pivot Grid widget which you need to hide the rows with empty or no values. 


Step 3: 
Open the filter measure window with the help of the Schema settings button available in Value(s) section. 


Step 4:  
In the Measure Filter window, set Ranges as “Greater Than” zero and click apply button. 
Step 4: 
Now the row with empty values are ignored both in designer and viewer. 

Before applying measure filter: 


After applying measure filter: 


Please let us know if you require any further assistance. 

Vinoth K. 

Live Chat Icon For mobile
Up arrow icon