Skip to Content
0

EPM report: subtotal on second dimension in rows

Sep 08, 2017 at 02:13 PM

46

avatar image
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

example.png (4.9 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Vadim Kalinin Sep 08, 2017 at 03:58 PM
0

Easy:

Result:


lm1.png (39.9 kB)
rep1.png (31.7 kB)
Share
10 |10000 characters needed characters left characters exceeded