Nope, that does not give the required result, because it is still an inclusive selection. See also in my post:
Note that this is not the same as inverting the selection: that gives customers that DO have transactions in any year apart from 2015, but that does not preclude those same customers from also having a transaction in 2015.
Your suggestion amounts to inverting the selction, which goves the wrong result as described above.
just to clear the situation
when you select 2015 ,
which customer appear in white , and which customers appear in gray
just rechecked it if you select 2015 , and then you select excluded in clients (assuming you see only clients that bought in 2015)
than you get only clients who didn't bought in 2015 , you'll notice that 2015 is changed to gary meaning there is no data to 2015
Let me clarify further with an example:
CustomerID | TransactionID | TransactionYear
0001 | 9001 | 2013
0001 | 9001 | 2014
0002 | 9001 | 2015
0003 | 9001 | 2011
0003 | 9001 | 2012
0003 | 9001 | 2015
Now, how do I define a filter that lets me select '2015', and gives me a resultset of CustomerID '0001' in this example?
I'm guessing I need to LOAD a specific new table for which I do a selection with some sort of EXISTS functionality, but I do not know how to do that.