topic Re: Display rules in Crosstabs in SAS Visual Analytics

Display rules in Crosstabs

akychong — Thu, 19 May 2016 21:11:09 GMT

Is it possible to apply display rules to only one categorical value instead for all value in a column.

For example, in the attached crosstab can I apply display rules to only FICO bucket ">=660" if Percent of column total is less than 70%?

Re: Display rules in Crosstabs

Renato_sas — Fri, 27 May 2016 03:52:24 GMT

Hi @akychong,

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.

Best,

Renato

Re: Display rules in Crosstabs

david27 — Wed, 21 Apr 2021 16:22:11 GMT

@Renato_sas

Has there been any progress on this since 2016?

Visual Analytics is generally used to present reports to senior management. Having an unnecessary column like that just does not sound right.

Regards

Re: Display rules in Crosstabs

AndreaZimmerman — Fri, 13 Aug 2021 21:15:51 GMT

You can now add such columns as a Hidden column which prevents them from being displayed, but still allows conditional formatting to be based on them.

Re: Display rules in Crosstabs

DJVA — Mon, 08 Aug 2022 15:08:14 GMT

@AndreaZimmerman Thanks for the update, but this isn't an option in crosstab objects which the original question is about, at least not in version 7.51 (build date = August 2021).
I have a similar use case: I have a cross tab with two aggregated measures, say x and y, I want to apply conditional formatting based on the difference between those two. Said difference is captured in a third aggregated measure (x - y basically).

The solution from @Renato_sas works functionally, but it's not pretty - if I can somehow fully hide the column which captures the difference that'd be great.