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. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

hide row in pivot grid

Thread ID:





129516 Mar 22,2017 10:22 AM UTC Mar 23,2017 12:34 PM UTC Dashboard Platform 1
Tags: Dashboard Widgets
Gregory Kohle
Asked On March 22, 2017 10:22 AM UTC


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 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. 


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.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon 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.Close Icon