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.
Unfortunately, activation email could not send to your email. Please try again.

hide row in pivot grid

Thread ID:





129516 Mar 22,2017 06:22 AM Mar 23,2017 08:34 AM Dashboard Platform 1
Tags: Dashboard Widgets
Gregory Kohle
Asked On March 22, 2017 06:22 AM


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.


Vinoth Krishnamoorthy [Syncfusion]
Replied On March 23, 2017 08:34 AM

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. 


This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.