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

Conditional formatting on Cross Tab

Reply
Occasional Contributor
Posts: 19

Conditional formatting on Cross Tab

    Hi

Please see the attached snapshot. I need to do conditional formatting (display rules) on the fields In_time, Out_time and login hours. I cannot convert them to numeric as there are other problems occuring then. Cross Tab report does not allow display rules on category variables but only on numeric.

Thanks

Manish


ConditionalFormatingNeeded.jpg
Trusted Advisor
Posts: 1,296

Re: Conditional formatting on Cross Tab

Hi Manish,

Is there a reason why you have chosen the CrossTab report object rather than a Table object? As the data items In_time, Out_time and login hours are column headers in the CrossTab they are not available for display rules (conditional formatting), however if you use a Table object you can set up a display rule for the 3 data items. If you require these specific data items to be category you could duplicate them and change the duplicated data item to a numeric too.

Kind Regards,

Michelle

Ask a Question
Discussion stats
  • 1 reply
  • 654 views
  • 0 likes
  • 2 in conversation