Background color Remain Same

[sunilkumarqv]

I have table 1

background color exp: if(Dim='Field',red)

then i select dim for dill down ,color will gone away how to remain same color

Note:I have table 1  for that i have drill down to other table 2

[#2]

if you 've  written the same expression may be you need to change the expression to if(Dim='Field',red())

[arsal_90]

if(Dim='Field',red(),'')

[sunilkumarqv]

Unfortunately that Doesn't Work

[manideep78]

Try this,

Go to Expressions Tab and in Background expression write like this:

If(GetCurrentField(DrillDownGroupName)='Dim', Red())

With the above expression you can set any no of colors for all the fields in a drill down group.

Hope this helps.

Regards

Manideep

[sunilkumarqv · Accepted solution]

Guys I cracked it

=if(count(DISTINCT{<Field=Something ,Dim1=,Dim2=>}1)=1,Red())

thanks  to you all yours help