Have bought vs. Have Not bought (Indirect Set Analysis)

[tmumaw]

Ok forum need your help. I have a screen where I want to show customers who have purchased a material group (selected by the user from a dropdown list), but not this material group (selected by the user from another dropdown list). Can anyone help out there or give me an example?

Thanks

Thom

[boorgura]

Did you try the P() and E() functions in set analysis??

[tmumaw]

I have been looking at them, but not too sure on how to code it because it's based on what the user selected from the list boxes. I have an example Sum({$<Customer = (P({1<Product = {'A'}>})) * (E({1<Product={'D'}>}))>}Sales). This is the example I am trying to work with but I don't understand what I would put in the product 'A' or 'D' because these are fields the user would select.

Thanks

[tmumaw]

Ok. I have tried these stmts with no luck. Could someone please explain what these statements are doing vs what I think they are doing?

sum({$<[Ship To] = p({$<[Material Group Code] ={'002'}>} [Ship To])>} [Subtotal 1] + [Subtotal 2])

sum({$<[Ship To] =E({1<[Material Group Code] ={'010'}>} [Ship To])>} [Subtotal 1] + [Subtotal 2])

sum({$<[Ship To] = P({1<[Material Group Code] ={'002'}>}) * E({1<[Material Group Code] ={'010'}>} [Ship To])>} [Subtotal 1] + [Subtotal 2])

Thanks

Thom