Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
DMG
Contributor III
Contributor III

Sum if two different values exist in same column for same id

I've a table of data where multiple rows exist for the same item, e.g.

Device     Value

1                 A
1                 B
2                 A
3                 A
3                 B

I want to sum the total number of situations where a unique device has rows of data that contain both A and B, so the result to the above data would be 2 

0 Replies