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.