Color code instead of color name

[rahulrackup]

Hi Everyone,

I have data wich talks about product categories by color code, and my requirement is to show sales amount by color code (see pic 2) instead of color name in table/Matrix format. Below snip of what i have in place and second picture talks about my requirement. Any help would appreciated.

Snip 1.

My Requirement Snip 2.

[rahulrackup]

Thanks a ton it worked!

[rocky09 · Accepted solution]

Try this one.

Category = 
        SWITCH(TRUE(),
       cc[Product Categories] = "Green", UNICHAR(128994),
       cc[Product Categories] = "Red", UNICHAR ( 128308 ),
       cc[Product Categories] = "Amber",UNICHAR ( 128993 )
        )