expression colour in straight table

[#1]

Hi Experts,

Is it possible to colour the expression based on the value of dimensions?

for eg:, my table has Dimension   Field1 : Red, Green, Orange 

                               Expression : count(expression)

i need to give different colurs to the expression value.

if Field1 ='Red', whitecolour for expression, if Field1= 'Orange', blue colour for expression.

is it possible? if so, can someone please help with expression?

[sunny_talwar]

I think you sure can...May be like this

Pick(Match(Field1, 'Red', 'Orange', 'Green'), White(), Blue(), Green())

[Anil_Babu_Samineni]

What do you mean the dimension colors here

[#4]

no sunny its not working

[#5]

Anil,

i want to give colours to expressions not dimensions

[sunny_talwar]

Can you show your table how it looks?

[#7]

sunny, picture attached

[sunny_talwar]

I don't seen any issues

[#9]

Its working sunny.

one more thing, if i select the any value in the 'Field1' in a list box, the value of my expression shouldnt change in this table.

my expression is count(callsanswered). if any calendar selection is made, then it should reflect the change.

can you please help?

[sunny_talwar · Accepted solution]

So changes based on selection in Field1?

May be this?

Count({<Field1>}callsanswered)

Color will change like this:

Pick(Match(Only({<Field1>}Field1), 'Red', 'Orange', 'Green'), White(), Blue(), Green())