A) a way to pass the data in the first table to the second
Answering this question, have you explored using Indirect Analysis? I had similar requirement in the past and I have got it working using Indirect Analysis. I am attaching a Set Analysis tutorial which contains Indirect Analysis. Using this approach you can pass the data from Table1 to Table2 on the fly and also considering the selections in Table1 (If any).
I hope this helps!
Cheers - DV
Thanks for your answer.
I have tried your way without success so far.
Included a QV where I show the base table, the intented outcome.
Based on your comment, one should be able to "read" into the initial table and group and count.
In my scenario, I can not use the direct way (as shown in intented outcome).
Any ideas how I can tackle this issue.
PassingValuesinTables.qvw 140.2 K