topic Background color Remain Same in Water Cooler

Background color Remain Same

sunilkumarqv — Mon, 14 Apr 2014 08:18:28 GMT

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

Mon, 14 Apr 2014 08:19:44 GMT

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

arsal_90 — Mon, 14 Apr 2014 08:40:48 GMT

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

sunilkumarqv — Mon, 14 Apr 2014 09:10:29 GMT

Unfortunately that Doesn't Work

manideep78 — Mon, 14 Apr 2014 10:14:57 GMT

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 — Mon, 14 Apr 2014 10:33:09 GMT

Guys I cracked it

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

thanks to you all yours help