Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Calculated members in AO 2.0 SP4

Hi Experts

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

Former Member
Former Member replied

Hi All

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

Thanks!!

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question