Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
Hope someone can help with this tiny design query
I have a pivot table with multiple condition background color expression - (ie if the value satisfies condition 1 paint it green, if condition 2 paint it red etc.). As you can see below it colours the values correctly, but what it also does is paint the background of the actual label "Solvency Ratio" with one of the gradients?
Is there a way to prevent this from happening?
Regards
Marek
Write like
Click on + in the expression and in background property write like
If(Yourexpression >= 10% and Yourexpression <= 90%,Red(),Green())
Some thing like in the expression background
could you attatch the file?
Use as below in your expression
IF(Dimensionality()<>0, YourExpressionForColor)
Something like below
IF(Dimensionality()<>0,IF(SUM(Sales)<100,Red(),
IF(SUM(Sales)<150,Green(),
Blue())))
Hi,
You can try something like this:
if( RowNo()>0,
( if(Sum(Sales)=1000,Red(),Blue()) )
)
You may want to look at the DIMENSIONALITY function. You can use it to exclude parts of the table by using something like If(Dimentionality()>0...)
Have a look at this discussion:
Hi Swuehl,
that discussion is long and old and also doesn't come to a resolution, so may not be the most helpful thing to read.
Regards,
James.
I think the issue described is still valid to the current situation.
And Matt's workaround described in the referenced thread might help (or maybe not, that's up to the OP's situation).
I see what you're saying. I would still suggest that the Dimentionality fix works better than using Visual Cues...