https://communities.sas.com/t5/SAS-Visual-Analytics/Calculating-unique-count-amp-sum-in-SAS-Visual-Analytics-7-4/m-p/610038#M13363 <P>Hi&nbsp;<a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/151178">@ASHISH2525</a>&nbsp;</P> <P>&nbsp;</P> <P>Could you please share a sample of data and specify he output that you want from this sample?</P> <P>Best,</P> <P>&nbsp;</P> Fri, 06 Dec 2019 17:09:29 GMT ed_sas_member 2019-12-06T17:09:29Z https://communities.sas.com/t5/SAS-Visual-Analytics/Calculating-unique-count-amp-sum-in-SAS-Visual-Analytics-7-4/m-p/610028#M13362 <P>Hi All,</P><P>&nbsp;</P><P>I want to calculate unique count from various months . for example in below snapshot a single user id has been tagged as ASP in two months &amp; total Asp is 3 but. unique is 2 only because same end user is repeating twice. is there any way to count it out &amp; display.&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="va.JPG" style="width: 451px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/34520i4960C25FCB3585A5/image-size/large?v=v2&amp;px=999" role="button" title="va.JPG" alt="va.JPG" /></span></P> Fri, 06 Dec 2019 16:37:45 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/Calculating-unique-count-amp-sum-in-SAS-Visual-Analytics-7-4/m-p/610028#M13362 ASHISH2525 2019-12-06T16:37:45Z https://communities.sas.com/t5/SAS-Visual-Analytics/Calculating-unique-count-amp-sum-in-SAS-Visual-Analytics-7-4/m-p/610038#M13363 <P>Hi&nbsp;<a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/151178">@ASHISH2525</a>&nbsp;</P> <P>&nbsp;</P> <P>Could you please share a sample of data and specify he output that you want from this sample?</P> <P>Best,</P> <P>&nbsp;</P> Fri, 06 Dec 2019 17:09:29 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/Calculating-unique-count-amp-sum-in-SAS-Visual-Analytics-7-4/m-p/610038#M13363 ed_sas_member 2019-12-06T17:09:29Z