Error in Background color using set analysis with data out of selection

[#1]

Hello everyone

I´m trying to format with color (Background ant text) dimensions and expresions in a chart table.

Everything is OK but when in I use an expresion with set analysis to get information that is not in the current selection, I loose this format

I send you an example of an app. Does anyone know how to keep the Background and Text Color

Thanks in advance

[maxgro]

try with (1 Orden for row)

=if(only({1}Orden)=1,RGB(255,102,0),

if(only({1}Orden)=2,RGB(192,192,192),

if(only({1}Orden)=3,RGB(0,0,0),

if(only({1}Orden)=4,RGB(255,102,0),

if(only({1}Orden)=5,RGB(192,192,192),

)))))

in expression and on first dimension only

[#3]

Hello Massimo,

thank you for your reply. It works but since I have a report with a lot of rows (each Orden number is a row) I created 2 tables (BackgroundColor and TextColor) linked with the Report Table in wich I include for each row the 2 fields

No my statement in the background and text script is as follows

=RGB(ColorFondo_R, ColorFondo_G, ColorFondo_B)

In each row of the report table I include the color that matches with the RGB color. It works fine in the first chart, but have the same problem un Chart 2 when I select the field Empresa2 and the chart have a set analysis that gets information out of current selection. In the expresion I have:

sum ({1 <Empresa={'Empresa1', 'Empresa2'}>}(Importe))

Do you know how to fix this issue so I don´t have to put and RGB format for each row since I design them in the report??

Thank you in advance