Help with Alternate state in chart expression

[#1]

Hi people,

Could you guys help me with the following problem

I have created 2 alternate states, and i want to get:

when state A = AA , State B = BB,

we will look for Last name(regardless of what the first name is ) :

i.e. Last Name  A has both AA and BB, so sum all amounts for the Last name A

      Last Name B doesn't have both AA and BB, so we ignore it.

       Again, we would ignore Last Name C.

Thanks

J

[sunny_talwar · Accepted solution]

B does seem to have both AA and BB... If you agree, try this

=Sum({<[Last Name] = P({<State = [StateA]::State>})*P({<State = [StateB]::State>})>}Amount)

[swuehl]

Or use an AND mode list box instead of the alternate states, this allows also to select more combinations of values, also using NOT.

AND-Mode

[#4]

Thanks Stefan for the suggestion, however the requirement is to use a different list box... so i will have to stick with the alternate state. but thanks for the suggestion, I will use it next time.