OTBI analytic: Populate a value in a column based on another column

Hi !

In my OTBI analysis I want to have column formula where I check if an employee have any value in column A.

If a value in present in column A for an emoloyee, I want to check what value are present in column B for the same row.

Then I want for the same employee populate a value in a new column C for all the rows having the same value in column B. Even if they dont have any value in Column A.

For example if I have follwing

EmployeeID|A|B|C

100|Yes|Halmstad|

100||Halmstad|

100||Orust|

101||Halmstad|