topic SAS VA conditional formatting based on row-column header value in SAS Visual Analytics

SAS VA conditional formatting based on row-column header value

hir_7 — Tue, 23 Aug 2016 04:50:37 GMT

Hi All,

Is there a way to format values in a cross tab based on the combination of row and column header values?

Please refer to the attachment. I need Toyota-Brisbane, Toyota-Los Angeles and Toyota-Paris values always coulored pink.

I couldn't find a way to do so using display rules.

Thanks in advance!

TedStolarczyk — Wed, 21 Sep 2016 20:19:06 GMT

hir_7:

A similar posting was asked earlier this year and a SAS employee responded with a possible workaround for that:

Re: Display rules in Crosstabs

I wonder if the same trick described above may work for you as well.

Sincerely,

Ted Stolarczyk, SAS Customer Loyalty team

hir_7 — Tue, 27 Sep 2016 05:37:28 GMT

Not neat as I have multiple combinations and will need to create multiple flags. However, should do the job for now. Thanks