Set Analysis Exclude

[mazacini]

I have 2 dimensions, ITEMCODE (which is a Product Code) and NAME ( a customer name), and a measure TR.VALUE.

I have a simple table with dimension NAME and expression Sum(TR.VALUE).

I want a table to show which customers have NOT bought a selected iproduct.

I tried this:

Sum ({$<NAME=E({1<ITEMCODE=>}NAME)>}TR.VALUE)

but this gives me an empty table.

Any ideas?

[thomas_skariah]

Hi,

Is it like there is a product code list box,and  when the selection is made the chart should show all the customers which is not associated with the selected product code.Is it right?

Regards,

Tom

[mazacini]

Yes, there is a product list box.

And, yes, I think you have described the requirement correctly - maybe I don't need the expression?

[thomas_skariah]

Hi,

You can use the attached application.

Hope it works.

Regards,

Tom

[mazacini]

Hi Tom

Many thanks - but I only have PE.

Could you describe solution?

Ta

Joe

[swuehl · Accepted solution]

You should be able to do what you want using the select excluded feature in the list box context menu on NAME list box.

If you want to do this in a table, automatically, you could create a straight table with dimension NAME and as expression:

Sum ({$<NAME=E(), ITEMCODE=>} TR.VALUE)