Armin

Recreated it in Excel, Columns A, B, C are given and I want to create Column D

in Count of ID when condition is met Comment by Armin April 22

@ColemenWilson It's just a table, with the IDs, customer status and I want to add the "Active Count" as a column.

in Count of ID when condition is met Comment by Armin April 22

So currently I have the following: COUNT(DISTINCT CASE WHEN `customerstatus` = 'Active' then `Customer ID1` END ) However for Customer ID1 "ABC" it shows 1 instead of 2 which I would like to see. If Customer "ABC" would have three with Active I'd like to see 3. In my data it actually is "Active" instead of ACTIVE

in Count of ID when condition is met Comment by Armin April 22

I had tried it with Count Distinct but it doesn't work :( Also in my actual data the 'Active' matches so that's not it as well.

in Count of ID when condition is met Comment by Armin April 22

Armin Member

Comments