Return dimension based on other dimension

[#1]

Similar to SQL :

select F2 where F1='test2'

the result in to the text box should be Canada

Thanks

[hector_munoz]

Hi,

Try this inside text box: =If(F1='test2', F2)

Regards,
H

[#3]

Thanks. I did it with Aggr function as actual data has more grouping.