Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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)
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.
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)
This worked perfectly. Thank you!