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

[tresesco · Accepted solution]

Calculated dimension: =

=Aggr(If( Not IsNull (

num(FirstSortedValue(

          aggr(sum(Stock15), Station, ArtikelomschrijvingLang, DateTimeNum),

           -aggr(DateTimeNum, Station, ArtikelomschrijvingLang, DateTimeNum)

),'#.##0 L')

) ,AROMAR), Station, AROMAR)

[kris_vliegen]

Thanks Tresesco,

Now it works :-)))

Regards,

Kris