Forum Discussion

rahulrackup's avatar
rahulrackup
Microsoft Employee
4 years ago
Solved

Color code instead of color name

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.

 

 

 

 

Need Help
  • rocky09's avatar
    rocky09
    4 years ago

    Try this one.

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

2 Replies

  • rocky09's avatar
    rocky09
    Solution Sage
    4 years ago

    Try this one.

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