OMG...What am I missing here? This seems so basic, but I can't seem to get the right result. Here is the source data...
I just want to count, for each ClientID, how many Actionable Items there (i.e. every occurrence where DR = 1 and Score >=2). I seem to only be getting the number or rows per Client ID.
The expected result should be ClientID 123 = 0, ClientID 456 = 0 and ClientID 999 = 1
The alignment of the source data columns might look off, but you get the idea...