Population based on SELECTION

[#1]

I have a large population of PRODUCTS.

I want to click on a PRODUCT which happens to be made in JAPAN and is a TOY.

Is it possible for me to select just this PRODUCT in a chart / listbox and have another chart populate with ALL TOYS THAT ARE BOTH MADE IN JAPAN AND IS ALSO A TOY?

I'm thinking this may be a aggr(sum) type expression maybe using the 'p' function.

Thanks in ADVANCE!

[pover]

In the other chart use set analysis to ignore the selection of product like the example below:

sum({$<PRODUCT=>} Amount)

That expression will still respect the selection of TOY and JAPAN.

Regards.

[johnw · Accepted solution]

Sounds like they won't actually select TOY and JAPAN, though. Rather, they'll select a particular product, and want to see products of the same type in the same country. So I think this?

sum({<PRODUCT=,PRODUCT_TYPE=P(),COUNTRY=P()>} Amount)

[#4]

This worked perfectly. Thank you!