Skip to Content
avatar image
Former Member

EPM report: subtotal on second dimension in rows

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

example.png (4.9 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Sep 08, 2017 at 03:58 PM

    Easy:

    Result:

    Add comment
    10|10000 characters needed characters exceeded