Distinct Count by Targets

[RMSLUIS]

Hi everyone,

I have a table with transactions, users, and transactions type...The idea is count the unique users by transactions type.....Someone can help me please?

Table 1				Table 2	?
Transaction ID	User ID	Transaction Type		Transaction Type	Count Unique User ID
1	U1	A		Only A	1
2	U2	B		Only B	1
3	U3	A		A and B	2
4	U1	B		Total	4
5	U2	A
6	U4	B

Many thanks

Rui

[camargos88 · Accepted solution]

Hi @RMSLUIS ,

Just create a calculated column to group the users and count them using distinct.

Did I answer your question? Mark my post as a solution!
Ricardo

[RMSLUIS]

works perfectly, thanks