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

hide row in pivot grid

Thread ID:

Created:

Updated:

Platform:

Replies:

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

Hi,

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

Regards,
Patrick


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. 

Regards, 
Vinoth K. 


CONFIRMATION

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.

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

;