Pivot - Background Color

[Anonymous]

Hi All,

Please guide me how to achieve the below one

Chart Type : Pivot

Background condtion : =if(Name='A',Green(),Yellow())

Dimension Background Color is working fine if it is in row format

If we drag ID dimension horizontally the background color is not working

my output should be

Thanks in advance

[sunny_talwar · Accepted solution]

Try unchecking 'Suppress Zero-Values' on the presentation tab and that should fix the issue

[Anonymous]

Thanks Sunny ,

Worked perfectly

Regards,

sam

[Anonymous]

Hi,

The same scenario above but with different condition

Back ground color condition : =if(sum(Sales) > 200,Green(),Yellow())  working if it is in row format

dragging ID dimension horizontally , back ground color is not working

Thanks in advance

[sunny_talwar]

Did you uncheck 'Suppress Zero-Values' for this chart?

[Anonymous]

Hi Sunny,

Yes un checked zero values in presentation tab..

Regards,

sam

[sunny_talwar]

Would you be able to share a sample to test this out?

[Anonymous]

Hi Sunny,

Sample Data

LOAD * INLINE [
Name, Id, Sales
A, 1, 100
B, 2, 200
C, 3, 300
];

Chart : Pivot

Dimension : Name, ID -> Horizontal

Background Color : Name -> if(sum(Sales) > 200,Green(),Yellow())

Expression : Sum(Sales)

Suppress Zero value - un checked

Regards

Sam

[sunny_talwar]

Try this:

=If(Aggr(NODISTINCT Sum(Sales), Name) > 200, Green(), Yellow())

[Anonymous]

Hi Sunny,

Thanks , perfect..

Regards,

Sam