Changing color of text

[#1]

Is it possible to change the text color of a certain field in the load statement or even in the pivot table?

basically here is what i want to do.

Set the visual cue to green if number of units is more than 50. But if the type of unit = toy then nomatter the number of units i want to set it to blue.

Any ideas?

[#2 · Accepted solution]

On the Expressions tab of your pivot table, click the plus next to expression (also works for dimensions) you want this to apply to and you should see text color. Right-click and choose Edit Expression. Type this:

If(FIELD = 'Toy', RGB(0,0,255))

That will be blue if it is a toy and then your visual cues will work. I think having null on the false end of that if is required to get to visual cue to work.