Color Coding in Pivot Chart

[ZoeM]

Hi Comunity.

I am trying to color code the Items in the month section of the Pivot table and I am unable to color code the concatenated items (see attachment). I have tried using a combination in the formatting under Expressions and I could not get it to work. Do I need to create a wildcard item?

[Cans,Scrapers]

[sunny_talwar · Accepted solution]

Try this

=If(Count(DISTINCT Item) > 1, LightRed())

[ZoeM]

Can I specify by combination? So if it Cans,Scrapers vs Trophies,Spades?

[sunny_talwar]

Not sure I understand, can you elaborate?

[ZoeM]

The method you specified when I applied it in my workbook changed all the different concatenated types. Am I able to specify which concan=tenated types should be a specific color?

Scraper,Trophies = RGB(100,150,200)

Cans,Scrapers = RGB(255,200,150)

[sunny_talwar]

Try this

=If(Concat(DISTINCT Item,',') = 'Cans,Scrapers', RGB(255,200,150),

If(Concat(DISTINCT Item, ',') = 'Scrapers,Trophies', RGB(100,150,200)))

[ZoeM]

You are just a genius Sunny, and a valid asset to the community!

You have no idea how I have suffered to get that together

[ZoeM]

Am I able to have a two color gradient within the cells?

I noticed that in the Styles tab in Properties I can have two gradient colors but it did not take effect when enabled. Also, in the Custom Format Cells right click option, it is disabled (greyed out).

I would like to see if I can have two colors for the fields that are concatenated: A diagonal gradient showing the two colros split for th eitem.

Any ideas?