https://communities.sas.com/t5/SAS-Visual-Analytics/VA-cross-tab-issue/m-p/447367#M9738 <P>I have a 6 list controls in my report viz. finyear,schemetype,schemedesc,state,brand,variety.</P><P>Suppose if i select one year with one schemetype and schemedesc, the multiple states data should reflect and if there is only one state will fall under this category it should not be show in report.<BR />And same should be applicable in cross tab also.</P><P>&nbsp;</P><P>Regards,</P><P>Harsh Patel.</P> Wed, 21 Mar 2018 10:46:26 GMT harsh1 2018-03-21T10:46:26Z https://communities.sas.com/t5/SAS-Visual-Analytics/VA-cross-tab-issue/m-p/447367#M9738 <P>I have a 6 list controls in my report viz. finyear,schemetype,schemedesc,state,brand,variety.</P><P>Suppose if i select one year with one schemetype and schemedesc, the multiple states data should reflect and if there is only one state will fall under this category it should not be show in report.<BR />And same should be applicable in cross tab also.</P><P>&nbsp;</P><P>Regards,</P><P>Harsh Patel.</P> Wed, 21 Mar 2018 10:46:26 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/VA-cross-tab-issue/m-p/447367#M9738 harsh1 2018-03-21T10:46:26Z https://communities.sas.com/t5/SAS-Visual-Analytics/VA-cross-tab-issue/m-p/449086#M9767 <P>Are you asking if you can prevent SAS Visual Analytics from displaying results in a crosstab if a control for the State category contains only one state?</P> Tue, 27 Mar 2018 18:14:09 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/VA-cross-tab-issue/m-p/449086#M9767 Madelyn_SAS 2018-03-27T18:14:09Z