Dynamically calculated column

Hi all,

I've col A and col B.I want to show a dynamically calculated col C which should be based on below logic:

If col A has no data then display col B Else display col A

Please suggest the best options to achieve this.

Can it be handled in cube views or requires dynamic calc member formula.

Thanks in advance