https://communities.sas.com/t5/SAS-Visual-Analytics/Crosstab-Display-Rule-on-a-Categorical-data-item/m-p/693674#M14363 <P>Hi Team,</P><P>&nbsp;</P><P>We have a requirement where we need to display hierarchy with categorical data items and measure value corresponding to a single categorical data item with that categorical data item value as colored.</P><P>We are using cross-tab object to display the same but unable to use display rule for a categorical data item.</P><P>Display rule is working for measure value but not for categorical data item.</P><P>Attached is the screenshot.</P><P>Based on the screenshot, we need to use display rule only on PIR_STATUS categorical data item which will contain 3 values as EXECUTED, PENDING and WIP.</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Vid2604_0-1603441685155.png" style="width: 533px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/50924i2C4DD5F2B14B0B8A/image-dimensions/533x154?v=v2" width="533" height="154" role="button" title="Vid2604_0-1603441685155.png" alt="Vid2604_0-1603441685155.png" /></span></P><P>Kindly suggest how can we accomplish the same.</P><P>&nbsp;</P><P>Many Thanks!</P><P>Vidushi</P><P>&nbsp;</P> Fri, 23 Oct 2020 08:31:19 GMT Vid2604 2020-10-23T08:31:19Z https://communities.sas.com/t5/SAS-Visual-Analytics/Crosstab-Display-Rule-on-a-Categorical-data-item/m-p/693674#M14363 <P>Hi Team,</P><P>&nbsp;</P><P>We have a requirement where we need to display hierarchy with categorical data items and measure value corresponding to a single categorical data item with that categorical data item value as colored.</P><P>We are using cross-tab object to display the same but unable to use display rule for a categorical data item.</P><P>Display rule is working for measure value but not for categorical data item.</P><P>Attached is the screenshot.</P><P>Based on the screenshot, we need to use display rule only on PIR_STATUS categorical data item which will contain 3 values as EXECUTED, PENDING and WIP.</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Vid2604_0-1603441685155.png" style="width: 533px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/50924i2C4DD5F2B14B0B8A/image-dimensions/533x154?v=v2" width="533" height="154" role="button" title="Vid2604_0-1603441685155.png" alt="Vid2604_0-1603441685155.png" /></span></P><P>Kindly suggest how can we accomplish the same.</P><P>&nbsp;</P><P>Many Thanks!</P><P>Vidushi</P><P>&nbsp;</P> Fri, 23 Oct 2020 08:31:19 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/Crosstab-Display-Rule-on-a-Categorical-data-item/m-p/693674#M14363 Vid2604 2020-10-23T08:31:19Z https://communities.sas.com/t5/SAS-Visual-Analytics/Crosstab-Display-Rule-on-a-Categorical-data-item/m-p/694469#M14371 <P>Hi Team,</P><P>&nbsp;</P><P>Looking for your kind help.</P><P>Kindly suggest workaround if any.</P> Tue, 27 Oct 2020 10:03:12 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/Crosstab-Display-Rule-on-a-Categorical-data-item/m-p/694469#M14371 Vid2604 2020-10-27T10:03:12Z