04-11-2016 03:50 PM - last edited on 05-19-2016 05:11 PM by ChrisHemedinger
05-26-2016 11:52 PM
I've thought of a workaround that hopefully works for you. In the example below, we want to only highlight percentages > 7.8% where Produc Brand = Novelty. By default, a display rule defined on Frequency Percent would highlight cells in the Toy row as well.
Solution: create a flag that is 1 only if the logic above is true (Frequency Percent > 7.8% and Produc Brand = Novelty), otherwise it's 0, then use this flag to define the display rule.
Downside: the new flag column needs to be added to the crosstab so it can be used in the display rule.
The first thing we need to do is identify the rows for Novelty. We do that by creating a calculated item called Is Novelty:
Next we are going to create the Flag as an aggregated measure:
Now we can add the Flag in the crosstab and define the display rule that looks like this (that's the only display rule needed - you can remove the one used initially):
To minimize the side effect and make the Flag column less noticeable, you can rename it to . (a dot) and define a display rule for this column that makes the font color the same as the background color.