Exploring, modeling, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

SAS VA conditional formatting based on row-column header value

Accepted Solution Solved
Reply
New Contributor
Posts: 4
Accepted Solution

SAS VA conditional formatting based on row-column header value

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!

 

 

Attachment

Accepted Solutions
Solution
‎09-27-2016 01:37 AM
SAS Employee
Posts: 32

Re: SAS VA conditional formatting based on row-column header value

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

 

View solution in original post


All Replies
Solution
‎09-27-2016 01:37 AM
SAS Employee
Posts: 32

Re: SAS VA conditional formatting based on row-column header value

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

 

New Contributor
Posts: 4

Re: SAS VA conditional formatting based on row-column header value

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

Post a Question
Discussion Stats
  • 2 replies
  • 396 views
  • 1 like
  • 2 in conversation