Mapping Help

[#1]

Hi All,

Greetings for the day!

I have 3 tables Fact, Dim1, Dim2.

Fact table contains BCode,Pcode,Amount

Dim1 contains BCode,Unit

Dim2 contains PCode,Region,Country

My requirement is if i select Unit = Unit2 and Country = Thailand then my actual Region = Asia

But as per my req i need to show if i select Unit = Unit2 and Country = Thailand then Region = China

I am attaching sample QVW also. Could you please somebody help me here?

Thanks,

QV 11 User