epm report

[former_member378690]

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?

[former_member186338 · Accepted solution]

Use row priority:

.

P.S. Please change the question primary tag, has to be:

EPM Add-In for Excel

[former_member378690]

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?

[former_member186338]

Sorry, are you sure that without report sceenshot and detailed description yuo will get some answer?