customized pyjama color in table

[menta]

Hi all,

i need to have a report in this way

A
A
B
B
C
C
C

I need to change color at change of the field value, in which way can I configure this?

Thank you

[#2]

Carlo,

Is this something you want to manually set or have dynamically change as you make selections?

[#3]

Hi,

Expand the Dimension/Expression you used and in Text color, give the Expression as if(FIELD='A' or FIELD='C',RGB(255,0,0),RGB(0,0,255))

Hope it helps.

Thanks.

[menta]

the table is a sample, i want to change dinamically the color, i don't know the values inside the field

[#5]

Could you be a little more specific with your scenario?  Using conditional statements with setting the RGB values is the right approach, but without more information its harder to give you more help

[its_anandrjs]

Load another color table to get color values dynamically see the example

Eg:-

Source:

LOAD * Inline

[

COL,Val

A,3

A,5

B,6

B,8

C,3

C,6

C,8

];

ColorTable:

LOAD * Inline

[

COL,RED,GREEN,BLUE

A,255,0,0

B,0,0,255

C,255,0,0

];

And then in chart in dimension click on + and in Text Color properties add the function RGB(RED,GREEN,BLUE)

Hope this helps

[menta]

I need a dinamic pyjama, the scenario is not important, i want to change the colour of the field value when this change,

[#8]

Well the way you'll write your expression will be different according to what the scenario is.  Otherwise strategies from other posters are general ideas of how to do things

[menta]

Ok, I attach a sample, I need something that works in same way as the pyjama style but dinamically on changing of the filed A. On changing of the value in field A i need to change his colour.

[#10]

Hi,

Go to Style in properties and change Current style to Pyjama Blue/Pyjama Green whatever Background color you need.

After that Right click on the Cell in the chart and select Custom Format Cell-> Text color

Hope that helps.

Thanks.