topic Re: Conditional formatting on Cross Tab in SAS Visual Analytics https://communities.sas.com/t5/SAS-Visual-Analytics/Conditional-formatting-on-Cross-Tab/m-p/138258#M76 <HTML><HEAD></HEAD><BODY><P>Hi Manish,</P><P></P><P>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.</P><P></P><P>Kind Regards,</P><P>Michelle</P></BODY></HTML> Wed, 10 Sep 2014 09:38:50 GMT MichelleHomes 2014-09-10T09:38:50Z Conditional formatting on Cross Tab https://communities.sas.com/t5/SAS-Visual-Analytics/Conditional-formatting-on-Cross-Tab/m-p/138257#M75 <HTML><HEAD></HEAD><BODY><P>&nbsp;&nbsp;&nbsp; Hi</P><P></P><P>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.</P><P></P><P>Thanks</P><P>Manish</P><BR /><IMG src="https://communities.sas.com/t5/image/serverpage/image-id/10834i8D2C65F7F4C555EB/image-size/large?v=1.0&amp;px=600" border="0" alt="ConditionalFormatingNeeded.jpg" title="ConditionalFormatingNeeded.jpg" /></BODY></HTML> Wed, 10 Sep 2014 07:51:35 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/Conditional-formatting-on-Cross-Tab/m-p/138257#M75 mjaitly 2014-09-10T07:51:35Z Re: Conditional formatting on Cross Tab https://communities.sas.com/t5/SAS-Visual-Analytics/Conditional-formatting-on-Cross-Tab/m-p/138258#M76 <HTML><HEAD></HEAD><BODY><P>Hi Manish,</P><P></P><P>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.</P><P></P><P>Kind Regards,</P><P>Michelle</P></BODY></HTML> Wed, 10 Sep 2014 09:38:50 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/Conditional-formatting-on-Cross-Tab/m-p/138258#M76 MichelleHomes 2014-09-10T09:38:50Z