Calculated members in AO 2.0 SP4
How do you achieve calculated members - Gross Margin as shown in below screenshot in hierarchy. ( Bex Source)
To achieve space (Row 24) I will be creating different table and using VBA to avoid overlap of crosstab ( by Martin - Thanks for VBA code)
Thanks for reading my post
I found 2 solutions this issue ->
Sol 1)Use SAPGetData formula and subtract the hierarchy node.
Sol 2)I have created separate report in sheet2 at hierarchy node and used excel formula at Gross Margin to refer sheet2. ( I am using this because of better performance)
I hope this will help someone