Text Color in pivot table

[#1]

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.

[jerem1234]

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!

[#3]

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