Local member in EPM report to calc % of total
I need to create a report that looks like this.
The percentage must be calculated as the account per row divided by the total shown in the row at the bottom.
I tried to create the local member with excel cell references (i.e. B4/B11) but that breaks when I expand one of the accounts shown, i.e. the B11 reference stays and so the calculation uses the wrong account.
I then had a look on the EPM Add-in Academy and found a video showing a solution that uses an EPMRetrieveData function in the local member. I replicated that in my environment (BPC 10.1 NW, EPM Add-in SP 20 .NET4) and all I get is an error message saying the function cannot be used. I tried this in my original report and then also tried to replicate the report from the video 1:1 and got the same error in both cases.
Would anyone have a solution for this report?