I have data that included individuals with different statuses. My goal is to only show individuals that have two specific statuses at the same time. In the example below, I only want to keep individuals that have a status of A AND C.
I tried a simple calculation:
(IF [Status] = 'A' and [Status] = 'C' then "both" else "other" END)
But it does not work.
I would appreciate any assistance.
Based on the table above, I would only want to show Frank Jones, James Carver, and John Smith.
You have two rows for Anne Brooke in your data so it was counting the A status twice. This calc will account for that and only count each Status once for each person.
if sum({ FIXED [Name]: countd( if [Status] = "A" or [Status] = "C" then [Status] end) }) > 1 then "both" else "other" end
