How to sum rows

[Former Member]

Hello,

My requirement is sum all the numbers in a row down below the report. However i can not use sum function as a local member. I have tried use formulas in formating sheet:

However this also didint work.

I would apperciate if anyone can help me to fix this issue.

PS: I have to solve this problem without using hierarchies. Thats why i am trying to use SUM or SUBTOTAL

Thank you in advance.

[Former Member · Accepted solution]

Thank you I have already tried this method.
It works for the reports with only one dimension in row but its not working when the row has 4 dimensions. Do you have any suggestion?

Thank you in advance

[former_member186338 · Accepted solution]

Just tested with 3 dimensions in row axis - works fine:

Vadim

[former_member186338 · Accepted solution]

P.S. Result:

[former_member186338]

Agree with Surabhi, it's a task traditionally solved by local member. You have to provide some strong arguments with examples why you can't achieve your requirements using local member. Then other methods like copy range can be discussed.

Vadim

[former_member230840]

Hi

One of the ways of doing it is to use the Local member with the formula EPMSELECTEDMEMBERS or EPMALLMEMBERS. Is there a specific reason you can not use local member?