Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Hi Christer,
try below code:
=Sum({< Product = E(Product), Customer = E(Customer) >} Quantity)
E() - excludes selected values
regards
Neetha