Background colours for 'Missing / Null' cells

[santharubban]

Hi All,

In the Pivot Table background coloring,the expression defining the color is an attribute expression, and it will only be calculated if the main expression is calculated. Coloring will not be applied if the first column result is missing or null values. Can give a work round for the same.

Thanks

Santahrubban

[sunny_talwar]

Try to check 'Suppress Zero Values' on the presentation tab.

[santharubban]

I need  to show zero values too

[tracysmart]

you can set it on the attribute of the dimension to background colour those that are null

=if(isnull(MyDimension), RGB(255,255,255))

or if its a null expression - you can do it on the attribute of the expression

=if(isnull(MyExpression), RGB(255,255,255))

changing the RGB to your colour

Hope that helps

[santharubban]

Thanks Tracy.

But it doesn't work, I have already tried.

[sunny_talwar]

Can you share a sample application where we can see this issue? Doesn't have to be your actually application, may be just mock up some data to show what you are seeing?

[Anil_Babu_Samineni]

Or

If(expression = '0' or expression = 'null' , red())

This expression would write expression BG color

[jpenuliar]

you can set Background Colour in "Visual Cues"

[santharubban]

no luck, it doesn't work

[santharubban]

no luck, it doesn't work