Forum Discussion
Solved
Conditional Formatting in CubeView in the "annotation" or other "Text" cell
I would like to apply conditional formatting to a Cube View column that contains "Annotation", "Variance Explanation" or other textual data.
I have tried IsNoData and "CellAmount" conditions, but ...
If you set the UD8 to Return a 1 if an explanation or 0 if not required.
Then set up a Delimited List Parameter where 1, 0 are the values and your Explain / Not Required text strings are the Display items.
Then set your CV column up to use this Combo Box as follows, note Modify Data = False means the cell will not allow drop down.
The cell value in the Cube View will display as Explain / Not Required but the cell amount will actually be 1 / 0 allowing you to perform conditional formatting.
Davy,
See my response above: currently the only available approach is the extender BR.
If you set the UD8 to Return a 1 if an explanation or 0 if not required.
Then set up a Delimited List Parameter where 1, 0 are the values and your Explain / Not Required text strings are the Display items.
Then set your CV column up to use this Combo Box as follows, note Modify Data = False means the cell will not allow drop down.
The cell value in the Cube View will display as Explain / Not Required but the cell amount will actually be 1 / 0 allowing you to perform conditional formatting.
Lee, Thank you!
Just tried this approach and it worked like a charm!
Glad to help!
Hi YanSavinsky
Can you share all the steps you followed (what type of ud8 is it - Dynamic or FormulaPass?)?
I've tried to understand this case, but I can't reproduce the correct configuration to be able to format the annotation cell.