Getting the values from another table

[Anonymous]

Hi

I have 2 tables say Table 1 and  Table 2 , I want to get Target and Bridge values from Table 2 without joining or concatenating in the data model .. my dimension for the chart is Category , so I need to find the value based on Category and User friendly metric name , match them and get the related Bridge and Target values .. how can I achieve that?

[sunny_talwar]

It does, and you might be able to remove some of the stuff, but I tried adding all the inner Aggr set analysis to the outer Aggr set analysis as well.