EPM report: subtotal on second dimension in rows

[Former Member]

Hi all,

I have a report which has ENTITY and ACCOUNT as the row axis elements. I have selected a node and the report shows the member and descendants for the entity dimension. I have also selected a set number of accounts for the account dimension.

What formula would I need to use for a local member to calculate the total of all accounts for each entity?

I would want the report to look like this

And have a local member for the yellow cells.

Thanks,

Arnold

[former_member186338 · Accepted solution]

Easy:

Result: