Colour code the row based on dimension

[Anonymous]

Hi All,

Is it possible to colour code entire row based on a dimension?

For example:

PolTerm	Qnums	Pnums
Cur	Q1244	P1256
Fut	Q1244	P5645
Cur	Q2345	P556
Fut	Q2345	P5647

Desired result

PolTerm	Qnums	Pnums
Cur	Q1244	P1256
Fut	Q1244	P5645
Cur	Q2345	P556
Fut	Q2345	P5647

Any help would be helpful.

Thanks,

Anupama Jagan

[sunny_talwar]

Yes you can, but you will need to right the same expression for each of your dimension and expression's background color expression

[Anil_Babu_Samineni]

May be this expression for all BG color expression

=if(Even(RowNo(TOTAL)), rgb(198,224,180), rgb(180,198,231))

[Anonymous]

I need this one based on polterm. for cur it should be in one colour and Fut in another colour. so I need to write the same expression on all dimensions and expressions?

[sunny_talwar · Accepted solution]

Yes... something like this

If(PolTerm = 'Cur', RGB(...),

If(PolTerm = 'Fut', RGB(...)))

Use this as background color expression for all your expressions and dimensions

[Anonymous]

But it wont be like this for all records.I just gave as example. it might be like this too

PolTerm	Qnums	Pnums
Cur	Q1244	P1256
Fut	Q1244	P5645
Cur	Q2345	P556
Fut	Q2345	P5647
Fut	Q3435	P987

Basically the colour coding must be on polterm.

[Anil_Babu_Samineni]

As Sunny, Mentioned you must use this for all Dim's and Expressions

=If(PolTerm='Cur', rgb(198,224,180), rgb(180,198,231))

[Anonymous]

Thanks a lot