How to set color for data in pivot table if there is missing symbols

[Peony]

Hi everyone.

I need help. There is table with data where some rows are needed to be filled in different colors due to some conditions. And everything is OK till I've moved column "Ouat" into horizontal view.

Because of empty cells that appears I've loose color filling for the cell with year "2010".

How can I fix it and return color to "2010" cell ?

Table:

LOAD * INLINE [

    Yr, Quat, Amount

2011, Q1, 12000,

2011, Q2, 15800,

2011, Q3, 1230,

2011, Q4, 1289,

2010, Q3, 9000,

2010, Q4, 125800];

Color conditions:

=if(Yr='2010',LightGray(),LightGreen())

[sunny_talwar · Accepted solution]

May be uncheck 'Suppress Zero-Values' on the presentation tab

[Peony]

Oh! It really helps! Thank you much!

[Peony]

I wonder, if there any possibility to keep 'Suppress Zero-Values'  checked and also to keep row color?

[sunny_talwar]

You can give a feel of 'Suppress Zero Value' checked by using this expression

Dual(If(Sum(Amount) <> 0, Sum(Amount), '-'), Sum(Amount))

But can't think of another way to do this where 'Suppress Zero Value' is checked