https://community.qlik.com/t5/QlikView/Calculating-Count-based-on-FirstSortedValue/m-p/1666831#M449187 <P>How to calculate the sum of counts when there are multiple records for one person ?</P><P>In the excel file attached, I'm trying to calculate the Clinical Disapproval Count for Lester for the previous quarter which is 2018-Q2.&nbsp; It is supposed to be 1+0+1 which is 1 but instead it is coming up as 4.&nbsp; &nbsp;The reason it should be 1 is because the&nbsp;Ordering_Physician_Specialty_Name is 'General/Family Practice' as&nbsp; this specialty has highest total request count, so for the General/Family Medicine, the Clinical Disapproval Count should be 1+0+0 = 1.</P><P>How can I get the total as 1 ?</P> Fri, 17 Jan 2020 16:45:02 GMT bob654321 2020-01-17T16:45:02Z https://community.qlik.com/t5/QlikView/Calculating-Count-based-on-FirstSortedValue/m-p/1666831#M449187 <P>How to calculate the sum of counts when there are multiple records for one person ?</P><P>In the excel file attached, I'm trying to calculate the Clinical Disapproval Count for Lester for the previous quarter which is 2018-Q2.&nbsp; It is supposed to be 1+0+1 which is 1 but instead it is coming up as 4.&nbsp; &nbsp;The reason it should be 1 is because the&nbsp;Ordering_Physician_Specialty_Name is 'General/Family Practice' as&nbsp; this specialty has highest total request count, so for the General/Family Medicine, the Clinical Disapproval Count should be 1+0+0 = 1.</P><P>How can I get the total as 1 ?</P> Fri, 17 Jan 2020 16:45:02 GMT https://community.qlik.com/t5/QlikView/Calculating-Count-based-on-FirstSortedValue/m-p/1666831#M449187 bob654321 2020-01-17T16:45:02Z