Variance Explanation Cube View
Hello,
Is there a way to format a cube view column for variance explanation to be a certain color/have text in the cell based on the variance column? The attached/below is what we want it to look ...
How are you populating the Variance Explanation in your screenshot above? You'll likely need a Dynamic Calc for that which will read the amount and then return a string of text to one of our Annotation View members. You won't be able to use a Dynamic Calc for the formatting portion. You'll have to use a BRString which is entered to the cell formatting property of the column.
