SAS VA conditional formatting based on row-column header value

[hir_7]

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 · Accepted solution]

hir_7:

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

https://communities.sas.com/t5/SAS-Visual-Analytics/Display-rules-in-Crosstabs/m-p/263004#M3888

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]

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