Hi,
I used sap bpc 10 nw for development. I develop one simple report using bpc excel. A report has Account as row axis, 3 field, 2 calculation field using local member (simple calculation). I need total from 2 field of local member. I try Grouping and After Grouping menu to produce it. But Total is not working for 2 calculation field.
How to make Total for calculation field of local member?
Sorry, are you sure that without report sceenshot and detailed description yuo will get some answer?
Column F has a simple formula=column(D)+column(E), I defined a formula using local members.
I need TOTAL, for column(D), column(E), and column(F). Currently, I defined TOTAL using local members and formula is SUM(EPMALLMEMBERS). I can see TOTAL in my report likes above, unfortunately, TOTAL for column(F) did not have formula SUM(), but column(D)+column(E).
Could you please inform me what should I do?