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
if you 've written the same expression may be you need to change the expression to if(Dim='Field',red())
Unfortunately that Doesn't Work
Go to Expressions Tab and in Background expression write like this:
With the above expression you can set any no of colors for all the fields in a drill down group.
Hope this helps.
Guys I cracked it
thanks to you all yours help
Retrieving data ...