2 of 2 people found this helpful
You can use Exclude option in Category Filter. [Filter --> Edit Filter]. And then select "Only Relevant Values" for dependent filter.
3 of 3 people found this helpful
Step1 : Create calculated field Calculation2 as follows.
Step2: Create Another Calculated field Calculation4 as per below image.
Step3: Create a last field Confition and use this field in filter shelf.
It will filter all clients who did not buy anything from network.
Let me know if this solves your problem.
Thanks for help!
Can I create a group of this clients?
I think if you 'group' the clients you will collapse them into a single line So B D E and would become Group 1. You could create a group variable and use it as the filter similar to how the 1 or 0 / True or False is used in the example below. You can also looking at creating a set for B D E. Possibly even a dynamic set so that it includes the appropriate clients each time the data source updates.