Create report of non selected items

[picturebox]

Hello,

I show in a report (pivot or straight table) across which stores a product has sold in which calendar week. I would like to turn that around and show where the product has NOT sold. The way I currently do it is to select the product and the time, then the list box of stores shows me the greyed out stores, so those that have not sold during that week ... how can I elegantly turn that into a report? Still using 9 SR7 ...

Thanks!

Petra

[swuehl]

Hi Petra,

you could try creating a straight table chart with dimension stores, and as expression

=only({<stores=e(stores), product=, time= >}stores)

You could hide the expression afterwards in presentation tab, if you want, so you only get one column with store names. You need to replace stores, product and time with your fields.

Hope this helps,

Stefan

[picturebox]

I am away from my system now til Monday, but one question: doesn't this method require that a store has at one point sold that product? I am not familiar with the excluded in a set analysis expression, I'll have to look that up.

Thanks, let you know if it works.

Petra

[swuehl]

No, I don't think that this is required. Please check attached sample.

Stefan