Hide rows with 0 value in Pivot-Table

[kris_vliegen]

Hi all,

To change the background-color of my pivot-tabel row by row I use =if(Even(RowNo(TOTAL)), RGB(192,192,192), RGB(165,165,165)) . If I do this for one expression or dimension the 0 values that were hidden show up.

Before:

After:

How Can I hide the empty rows?

Regards,

Kris

[#2]

the formulas which you are using on "Expression" tab, same should available on background colour also.

In community you can find more discussion on this..

Karthik

[kris_vliegen]

Hi,

I put the formule in the background-expression.

[#4]

Tick the box Chart properties -> Dimensions -> Suppress When Value is Null.

[tresesco]

Hello kris,

Use calculated dimension for 'Datum' like : =If (Not Isnull(Voor.ma) , Datum)  , and then check 'Suppress When Value Is Null' for it in the dimension tab.

If Voor.ma is calculated value, then you might have to use Aggr function to achive the same in the calculated dimension.

[kris_vliegen]

Hello Tresexco,

The column 'Voorr ma' is a calculated value (see below)

What should i do in the calculated dimension?

[kris_vliegen]

Hello,

this is not working. I had done this first but didn't work for my pivot table.

Regards,

Kris

[tresesco]

Try something like:

=Aggr(If (Not Isnull(YourExpression with firstsortedvalue) , Datum), Station, Omschrijving, Datum)

Assuming you have two dimensions(Fields) in the pivot apart from datum named Station and Omschrijving.

If this does not work, please share your sample app.

[#9]

Did you tried to replace nulls with zero, and after, hide zero values ?

[kris_vliegen]

I've just tried this: If(isnull calculation, 0 , calculation)

And then in the presentation tab suppress zero-values.

But this doesn't work.

Regards,

Kris