Dynamically calculated column

Rev
New Contributor

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

1 REPLY 1

JackLacava
Honored Contributor

I'm no CV whiz, but I'd say for something like that you will need either a custom GetDataCell function or a DynamicCalc member.