Summarize / Group By

[T_Lina]

Dear Alteryx community, 

I have another challenge that I cannot seem to get my head around.

The summary tool with group by on class and then counting the numbers does not give me the correct results.

This is what my file looks like:

Number	Item	Class
1234	1	A
1234	2	A
1234	3	B
1234	4	C
5678	1	A
5678	2	A
5678	3	C

 And this is what I want to achieve: 

Result: How many numbers are assigned to each class

A	2
B	1
C	2

Thanks a lot in advance!

BR

[mceleavey · Accepted solution]

Hi @T_Lina ,

You are trying to count the different combinations of Class and Number so you need to add a Count Distinct on Number:

Hope this helps.

M.

[T_Lina]

Thanks a lot @mceleavey - it worked !! 🙂 

[mceleavey]