Arjan

Can you set the Clients field to data type category? If so, define a Named Query that excludes the 4 clients, then any Table View that you set to aggregate by Product will exclude any products sold ONLY to any one or several of the 4 excluded clients.

If there are too many unique client names to set the field as Category, define an Named Query initially including All records, then use text filters to isolate the rows for each excluded client, then use the Query: 'Remove filtered data from query' option to eliminate the records for each excluded client. Once you are finished excluding the records for the 4 clients, save the Query named "All less 4 excluded clients" or similar and set all your views to display this Named Query subset intersected with the Sidebar filters as usual.

Thanks Tom,

Good option using the queries for this.
But is there a way to configure it more flexible? Could the Filter-Out option be used for this?
If not, what is it used for normally?

Thanks Arjan

If you are working with formulas, all formulas are calculated on the unfiltered data, so filtering has no effect on unique values, etc.

However, if you're not using formulas, you should simply be able to select those 4 clients and click "Move". Then use the Bar view to show unique products, or use aggregation in any view (such as a table view).