Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello all, I would like to ask you for your help with coloring and set analysis.
Issue that I am having (please take a look on the file that I am attaching) is the when set analysis is used (second expression) coloring is not working. When you select let’s say April as month, you can see that Business unit column is not colored green. When nothing is selected Business unit is colored. What I need is that regardless what is selected, those rows should be colored by a condition specified in Background Color option. So even though regular expression is showing 0, coloring of first dimension should be implemented
Thank you in advance
try this expression
=only({1}if(Project='Project4' or BusinessUnit = 'BU1', Rgb(106,168,79)))
Is your condition is correct, =if(Project='Project4' or BusinessUnit = 'BU1', Rgb(106,168,79))
If condition correct then output giving exactly as per condition
hi
use this expression
=if(only({1}Project)='Project4' or only({1}BusinessUnit) = 'BU1', Rgb(106,168,79))
also have a look at the attach file
try this expression
=only({1}if(Project='Project4' or BusinessUnit = 'BU1', Rgb(106,168,79)))