Change background color of missing

[k_burata]

Hi,

I have these 2 tables below

Now I want to create a pivot table and transpose the date so it looks something like this:

question is how do I identify the null cells and change it's background color.

It's getting the not nul bit but not working for missing values

[Gysbert_Wassenaar]

Try changing the null values to 'null' string values:

Set NullValue='null';

MyTable:

LOAD stuff FROM somewhere;

[k_burata]

Hi Gysbert,

Sorry edited my question just now.

Regards,

[Anil_Babu_Samineni]

Check this?

Expression

=If(count(NoOrder)>0, count(NoOrder), '-')

BG Color

=If(count(NoOrder)>0, RGB(0,0,255), RGB(255,0,0))

[Gysbert_Wassenaar]

You can't give cells without a value a background color using the Background Color setting. That's why you need to replace null values with real values.

Well, not quite true. You could give the entire table a background color and then give the cells that do have a value a different color.

[Zhandos_Shotan]

Hi!

Here is one click solution :

Open Chart properties,

Go to Presentation tab,

Uncheck Suppress Zero-Values

Apply

Best Regards!