Merge two dimension as one

[former_member402770]

Hi Experts,

I am trying to create an webi report formula combining two dimenson object as one. My DB is HANA universe

How to write an webi formula to INSERT the Type2 dimension only matching row of values into Type 1 to display the Type1 LOV as attached screenshot

Appreciate your help on this,

Thank you very much

Dinya

[amitrathi239 · Accepted solution]

try with below formula.

=if([Type1]=[Type2]) then sum([Actual of first table]+[Actual of second table]) else [Actual of first table]