client_id: 1 2 3
type_file: A B C
In a pivot
- client 1 got A and B
- client 2 A and C
- client 3 just C
With the filter type_file, type_file and client_id in rows:
if i say "include A" client_id 1 and 2 will be displayed and we will only see type_file A
If i say "include C" client_id 2 and 3 will be displayed and we will only see type_file C
If i tip A and C "include A and C" i will see client 1 2 3:
In 1 we'll see type file A
In 2 we'll see type_file A and C
In 3 just C
How can i use advanced filter to say "only C", in a way that only client_id 3 because only him has only type_file C.
How can i use advanced filter to say "only A and C" in a way that only client_id 2 is displayed because only has both type_file A and C.
How can i say "A and not B" to obtain the same exact result.
Please sign in to leave a comment.