I would like to visualise the result of an analysis where I compare sets of products offered by a company and the demand of customers for these products. The idea is that the user can explore different matches for specific customers in the sense of "If I offer this customer a certain set or a combination of sets, will their needs be satisfied?"
The input tables look like this:
And the results like this. There are three potential "buckets" for a product:
I would like to visualise the result buckets as simple tables. Then on top of these tables two filter panes, one for 'Set configurations' one for 'Users'.
Although, I must confess the set analysis for each of them was a trial and error because for some reason they weren't behaving properly. Especially the last list box (Unfulfilled customer needs) was random. I think we need more guidance from marcus_sommer or swuehl to make sure that
1) these sets are doing what you need
2) if there are betters ways to do this
3) why was Unfulfilled not working with just Aggr(, Product) and needed Customer, Set as dimensions where as Product w/no demand worked without Customer, Set.
UPDATE: Just so other's who cannot download the file can view the expression:
As I understood the OP, he want the tables to react to selections in Customer and / or Set:
"The idea is that the user can explore different matches for specific customers in the sense of "If I offer this customer a certain set or a combination of sets, will their needs be satisfied?"
I think your last list box only needs Product and Customer as dimensions (not all three fields), not really sure why using Product only does not work. It's always harder for me to trace back set analysis with operators working on record sets.
Note that all my three list list boxes only require a single aggr() dimension Product.
David, please note that my middle table should have a caption 'Products with demand', this is a copy & paste error.