How to get the count/data of costumer with unique / distinct request(Expression)?

[userpd_2021]

Hi All,

My requirement there is to get the count of costumers who have an unique or distinct request which is not associated with other Costumers.

Ex:Below is the list of costumers and their request with the location . I want to pick out customers with unique request att the same location.

Customers	Request	Location
C1	TV	Loc1
C2	TV	Loc1
C3	Radio	Loc1
C4	Laptop	Loc1
C5	Mobile	Loc1
C6	Mobile	Loc1
C7	Mobile	Loc1
C8	Washing Machin	Loc1
C9	TV	Loc2
C10	TV	Loc2

Result: As Customer 3 , 4 and 8 have unique request I want to only show this unique combination. How can this be performed?

Customers	Request	Location
C3	Radio	Loc1
C4	Laptop	Loc1
C8	Washing Machin	Loc1

[maxgro]

maybe a table with 2 dimensions,

Customers, Request

and one measure

IF(count(TOTAL <Request> Request)=1, Location)