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