hide row in pivot grid

[Gregory Kohle]

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]

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.