how to make an expression to show me what has not sold in a certain period?

[chriscools]

Hello,

i can make a list of qty sold per article the last year in our own country, but now we have to prepare for an outlet-event.

and i would like to have a list of all the articles where nothing has been sold the last year in our country (or another chosen period/country).

How would i have to set-up this?

Can someone give me a clue?

thanx!

chris

[swuehl]

Use set analysis with a set modifier with implicite field value definitions, like the e() function:

sum( {$<Customer = E({1<Product={‘Shoe’}>})>} Sales )

returns the sales for current selection, but only those customers that never bought the product ‘Shoe’. The element function E( ) here returns the list of excluded customers; those that are excluded by the selection ‘Shoe’ in the field Product.

[check the HELP for more detail]

Or in your case, something along these lines e.g. in a list box field expression:

=aggr(only({<Product = e({<Year = {2012}>}) >} Product), Product)

[chriscools · Accepted solution]

thank you very much i will try this immediately!

grtz,

chris