Color Expression Based on Change of Values

[#1]

I have a pivot table which shows values (expression) side by side based on a different dimension. Is there a way to write a statement on the font color of the expression to perform the following?

The dimension is numeric, therefore if the expression in the max dimension is different than in any other dimension do X (e.g. bold, black, etc.) or be the default format.

[varunreddy]

Hi,

Try This as background colour for expression,

if(Dimension = max(expression), Blue, RGB(179,179,179))

Hope this works!

Regards,

Varun. K

[gautik92]

expression->Text Color

if(Dimension=Max(Exprssn),Red(),Yellow())

[#4 · Accepted solution]

Thanks everyone for your input. I was able to resolve. Here is the syntax I used below in case others have this issue:

IF(ONLY([Expression]) <> AFTER(TOTAL ONLY([Expression])) AND NOT ISNULL(AFTER(TOTAL ONLY([Exoression]))), RGB(3,5,243))