Showing the inverse of a selection in a list box (or table)

[#1]

I have, what I hope, a simple problem.

I have a standard list box that shows a list of items with possible values in white and other values in grey.

I'd like to show, in another read-only box (table or whatever), what I would get if I right-clicked in the first box and selected "Select Excluded".

Tried different approaches with set analysis, but couldn't get my head around it.

Any hints?

[Anonymous]

Hi Christer,

try below code:

=Sum({< Product = E(Product), Customer = E(Customer) >} Quantity)

E() - excludes selected values

regards

Neetha