Create a table with a value replacement in the field country if specific condition

[novicenovice]

Dear all,

I want to create a table by replacing the values in country field if the segment is for instance "S01"  but I don't know how to proceed.

here below my current function : 

GROUPBY(SELECTCOLUMNS(V_MARGIN;"SEG";RELATED(V_SEGMENT_GROUP[SEGMENT_GROUP_DESCRIPTION_BIS]);"CTRY";RELATED(V_CUSTOMER_FORECAST[#COUNTRY]));[SEG];[CTRY])

In advance thanks for your help

[v-juanli-msft]

Hi @novicenovice 

Is your current formula correct?

It seems incorrect.

Could you show me some examples for better analysis?

For example,

you have three tables involved in the "groupby" function,

show a little data of these three tables and show me expected result table based on those tables.

Best Regards
Maggie