How to retrieve values not selected in a slicer?

[Anonymous]

In my report, I have a slicer column with almost 8000 id values, among which I have to exclude a small set of ids (different values, dynamic based on user). And my table should display a list of customers and their details based on selection.
So, I had tried Select All and then deselect the ids which should be excluded.
Now, my problem is I want to show the ids excluded from the table.
Is there any way.

[Greg_Deckler · Accepted solution]

Sure, you can create a var that is ALL of your table and the. Do an EXCEPT and CONCATENATEX the values.