An easy ask.. calculate users across multiple rows to see who has multiple products

[sharpedogs]

I have a set of users with a product installed, some have Pro and some have Standard and some have both. I want to count the ones who only have Pro, the ones who only have Standard and the ones who have both. Sameple dataset below 

Chad has both installs, while Sarah and Jeff only have one install..

I had tried a   calcualate(user), (version = "pro") && (verison ="stnadard")... excuse the syntext.. new to it... but this didn't work? 

Product	Version	User
Adobe	Pro	Chad
Adobe	Standard	Sarah
Adobe	Standard	Chad
Adobe	Pro	Jeff

[Anonymous · Accepted solution]

hi @sharpedogs 

Is it not solved by using a matrix?

Jan 

[Anonymous · Accepted solution]

hi @sharpedogs 

Is it not solved by using a matrix?

Jan 

[AlexAlberga727 · Accepted solution]

I agree with @Anonymous . Matrix is all thats needed really.

You can even go about it slightly differently. If you would rather view by Employee , and their number of subscriptions -