How to calculate the sum of counts when there are multiple records for one person ?
In the excel file attached, I'm trying to calculate the Clinical Disapproval Count for Lester for the previous quarter which is 2018-Q2. It is supposed to be 1+0+1 which is 1 but instead it is coming up as 4. The reason it should be 1 is because the Ordering_Physician_Specialty_Name is 'General/Family Practice' as this specialty has highest total request count, so for the General/Family Medicine, the Clinical Disapproval Count should be 1+0+0 = 1.
How can I get the total as 1 ?
