Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear all,
How do i get values that exists in all selections?
For example i want to get all customers that exist in Club A and (not or !) exist in Club B etc..
Thanks,
Bunim.
@Bunim can you share a sample data and the expected output ?
The table look like this -
Club | Customer |
A | Moty |
A | Bunim |
B | Bunim |
B | Rivka |
B | Miriam |
C | Moshe |
C | Sara |
I have a filter on Club that i can select A or B or C.
I have a KPI that count Customers. so without selection i will get the count for all Customers and if i select A the count will be 2 (Moty and Bunim).
I want that if i select A and B i will get 1 because they have only one Customer the same (Bunim).
Thanks.