Thank you for your reply.
Unfortunately this does not provide the solution I'm looking for. I need to be able to place both related and unrelated data in - for instance - a straight table. Now I can't combine unrelated dimensions on a single row in a table. I also tried several 'join' inputs in script but they won't provide me a solution as well.
Any other ideas?
Thank you for your reply Peter. You are right, I don't want unrelated data to hide but instead i want to show an empty cell if there is no related value. For instance, if I select 10 products and 1 customer who has 5 of these products priced, I want to show 10 products with 5 prices and 5 empty cells. If another customer has 7 prices, I want to show 10 products with 7 prices and 3 empty cells. Do you have any suggestion here?
Bringing it back to my tables, my customers fields are in two separate tables and I would like to join them in order to only have to select one field instead of two fields. My efforts so far give me the problems I earlier described. I've made a simple illustration hereunder.
How I want it to be:
When I select a customer in C (or customer group in D) I want to get the related values in A and B (both table 2 and 3).
How it is now:
Now when I select a customer in C (or customer group in D) I get the related values in A (table 2). If I also want the related values in B (table 3) I also have to select the same customer in E (or customer group in F).
So in essential it is all about having to select only 1 field for customer or customer group instead of 2 fields. I don't want multiple customer field names with (sometimes) identical data values.
Thank you in advance!