Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a Pivot with expression as below
Count of Status=Count(DISTINCT {<Status={'PASS'}>} RUN_ID)&' '&Count(DISTINCT {<Status={'FAIL'}>} RUN_ID)
and Dimesion as SET_ID and RUN_ID .RUN_ID s are grouped by SET_ID.
I need to give text color for expression as 'Green' to Pass count and 'Red' to Fail count.
Any idea for this?
Thanks in Advance.
It's not possible to have two different colors for one "value" of an expression (i.e. |25 10|).
Make two expressions, one for pass and one for fail:
Expression 1:
Count(DISTINCT {<Status={'PASS'}>} RUN_ID)
Expression 2:
Count(DISTINCT {<Status={'FAIL'}>} RUN_ID)
Then you can click on the "+" next to the expression, and change the "Text Color" to something like
=green()
or
=red()
or
and rgb() value.
Hope this helps!
Hi ,
To give Text Color follow the steps,
go to Pivot Table Chart Properties > Visual Clues (Tab) > Select the expression > And then You can Set the Upper and Lower Value and Also the Color For the Text as You want.
See the attached Image.
Hope It Helps you,
Regards,
Ravikant