https://communities.sas.com/t5/New-SAS-User/created-a-distinct-count-when-i-am-using-same-in-report-after/m-p/554175#M9464 <P>i have created the distinct count&nbsp; of a one category in sas va, and i have used the same in my report and used drop down list filter and in the property tab i have used the option show coloum totals . but after filtering the total is showing wrong (means it is showing only distinct count of a category(attached a screenshot)) after filtering also i want to make it as a dynamic( after every filter total should change) please help to achieve this.</P><P>&nbsp;</P><P>Thanks And Regards,</P><P>Arun</P><P>&nbsp;</P> Fri, 26 Apr 2019 06:50:52 GMT sajjanarun 2019-04-26T06:50:52Z https://communities.sas.com/t5/New-SAS-User/created-a-distinct-count-when-i-am-using-same-in-report-after/m-p/554175#M9464 <P>i have created the distinct count&nbsp; of a one category in sas va, and i have used the same in my report and used drop down list filter and in the property tab i have used the option show coloum totals . but after filtering the total is showing wrong (means it is showing only distinct count of a category(attached a screenshot)) after filtering also i want to make it as a dynamic( after every filter total should change) please help to achieve this.</P><P>&nbsp;</P><P>Thanks And Regards,</P><P>Arun</P><P>&nbsp;</P> Fri, 26 Apr 2019 06:50:52 GMT https://communities.sas.com/t5/New-SAS-User/created-a-distinct-count-when-i-am-using-same-in-report-after/m-p/554175#M9464 sajjanarun 2019-04-26T06:50:52Z https://communities.sas.com/t5/New-SAS-User/created-a-distinct-count-when-i-am-using-same-in-report-after/m-p/554549#M9526 <P>Do a proc contents on the table and check the length and format of the variable.&nbsp;</P><P>my Hunch is it &nbsp;is set to less than 8 to save space ?&nbsp;</P> Sun, 28 Apr 2019 01:48:05 GMT https://communities.sas.com/t5/New-SAS-User/created-a-distinct-count-when-i-am-using-same-in-report-after/m-p/554549#M9526 smijoss1 2019-04-28T01:48:05Z