Forum Discussion
YanSavinsky
4 years agoNew Contributor III
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 ...
- 3 years ago
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
3 years agoContributor
did you find a solution ? I have similar requirements
YanSavinsky
3 years agoNew Contributor III
Davy,
Please see LeeBown's post below for a solution not requiring Extender BR. I tested it and it works.
Related Content
- 3 years ago
- 3 years ago