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. Belo...
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 )
        )
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 )
        )