Count distinct between two fields.

[Anonymous]

Hello Everyone,

Need an urgent help.

Say I have two fields like Location and Attended_PeopleStatus where location field will have duplicate values.

Now I want the count of distinct status according to Region.

Location	Attended_PeopleStatus
A	0
A	0
B	0
C	0
C	0
C	0
C	0
D	1
D	1
E	1
F	1
F	1
F	1
G	1

Output Count of Attended_PeopleStatus should be:

0 - 3

1 - 4

Can anyone please advice how can i achieve this.

Thanks,

Ipsita

[sunny_talwar]

May be like this

Dimension

Attended_PeopleStatus

Expression

Count(DISTINCT Location)