Issue with pivot table

[#1]

Hi.

I have at pivot table where I first have a overall view end when I expand it I get a more detailed view where I mark values thar are <= 1 as red.

That works fine but I would also like to have red cell when it is collapsed. See attached pictures.

[fernando_tonial]

Hi Tony,

When is collapsed, i don't see values one for mark red?

Best Regards.

Tonial.

[#3]

Hi Fernando, look in attached picture "pivittable1.png".

[fernando_tonial]

Ok.

In attached picture "pivittable2.png", all values are bigger than 1, if you change your rule for <= 30, you see the red mark.

[#5]

It is not that easy.

When the table i expand - if one Station have the value <=1 then the cell should be red

When the table i collapse - if one station for a Area have the value <=1 then the collapsed cell should be red.