Options to display expanded nodes table and sub-components?

[#1]

Hello,

there are two tables - the one at the bottom (table 2) has certain Store-level statistics (metric1,metric2,metric3). The table on top (table 1) is an expended nodes table, with geographical hierarchy of store locations. Table 1 has pre-aggregated metrics (metric1,metric2 and metric3) based on the data from table 2. Note: Pre-aggregation requires a complex algorithm and IS NOT something which can be done with qlikview functions.

Now, the question is what are the possible options to display data from table 1 so that various levels of hierarchy would have their appropriate values of metric1,metric2,metric3 next to them? If aggregation was possible, pivot table is the obvious choice. But how would you do it in my case?

Another question, how to link the data so if user clicks on an item from table 1(let's say on something in Level 3) column, the selection will get only the records with the same Level 1 and Level2 and Level 3 values from table 2? In other words joined on all three fields, not just one.

Any hints, tips, help will be very appreciated!

Thank you!