Conditional color for pivot table

[Anonymous]

Hello,

I would like some help with an expression to get conditional color for my pivot table. If one of the products appears twice in this case "Shoes" then i would like the colors "green and yellow ' to be highlighted in yellow.

Kind regards,

Esther

[antoniotiman · Accepted solution]

May be

=If(Count(TOTAL <Products> Colours) > 1,Yellow())

in Conditional Color.

Regards,

Antonio

[devarasu07]

Hi,

try like this.

=if(Aggr(count ({<Colours=>}Products),Products)>1,Yellow(),White())

[Anonymous]

Sorry I was not clear, my desired outcome is below.

[sunny_talwar]

A little modification to Antonio‌'s expression should work for you

=Aggr(If(Count(DISTINCT TOTAL <Products> Colours) > 1,Yellow()), Products, Colours)

Or this

Aggr(If(Count(DISTINCT Colours) > 1, Yellow()), Products)

[sunny_talwar]

A little modification to antoniotiman‌'s expression should work for you

=Aggr(If(Count(DISTINCT TOTAL <Products> Colours) > 1,Yellow()), Products, Colours)

[Anonymous]

Thank you, it works

[Anonymous]

Thanks