Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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))
Hi,
Try This as background colour for expression,
if(Dimension = max(expression), Blue, RGB(179,179,179))
Hope this works!
Regards,
Varun. K
expression->Text Color
if(Dimension=Max(Exprssn),Red(),Yellow())
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))