Set Analysis Problem

[Anonymous]

I'm trying to figure out how I can get one chart to reflect current selections (no problem) while another chart displays only possible selection minus the current selection.

This image should show what I'm after (the image doesn't show the expression columns where the Set Analysis would be inserted).

[jolivares]

In your expresion for the second chart, that is not affected by the selection, include a expression like:

Sum({<LotCode=>} Amount)

[Anonymous]

I tried that but the selected Lot Code (in Green) is still in the 2nd chart. I only want the ones in white (associated values).

[jolivares]

Ok... this is the possible values, you have to use

Sum({<LotCode = P(LotCode)>} Amount)

[Anonymous · Accepted solution]

Not quite, but you pointed me in the right direction. This worked:

sum({<[Lot Code]=E([Lot Code])>} Amount)

[rustyfishbones]

Hi Brian,

Can you mark your own answer as correct, just makes it easier for the rest of us to find what we need

Thanks

neet solution BTW

Al