Hyde a row in a pivot table

[Roberto_Licciardello]

Hello,
I have a problem that I cannot solve.
in a pivot table I want not to see a row if one of the measures is equal to 0.

for example the lines marked in red in the figure must not be seen.

thank you so much

[Fernando_Fabregas]

Hi Roberto. You can try this: 

1) In all measures of pivot table (except "YourFieldToCheckZero"), add the following condition: 

   if( Sum( YourFieldToCheckZero ) = 0, 0, Sum(YourMeasureY) )

or....

    if( Column(x) = 0, 0, Sum(MeasureY) )            

Replace the "x" with number of column to check. This works only if user don't swap columns.

2) Uncheck "Include zero values" in Data Managment panel

It should work fine...

Regards, Fernando

PD: che bella machina la Alfa Giulia !!

[Roberto_Licciardello]

Hi, thanks for the reply. I try with solution 1) modifying it a bit.

I have already put 2 in place, but I have more than one column in the pivot table