I have a report with three dimensions (account, entity, auditid) in the row axis. The order is set in this way due to client requirements. The report essentially looks like this
I would now like to add a local member that calculates ACCOUNT_NODE/ACCOUNT2 but still allows me to drill-down on the entity and auditid dimensions. So I am looking for something like this
The only way I can see would be to create the local member using an epmretrievedata function. When I try to create it local member recongnition, it does not work since the entity and auditid are not repeated or shown on the row for the local member. so my result looks like this
Is there a way to create the local member in the way I need it?