Skip to Content
0

two account ID in the same rows

Dec 15, 2016 at 08:54 AM

48

avatar image

Hi Bpc Friend

I have a report quite complex.

For a section of this report, the user doesn't want anymore to separate the Total Operating expenses and the shared service total but would like to have row by row the sum of both by category.

How can I have in the same row both?

Thanks

rkair.png (57.9 kB)
10 |10000 characters needed characters left characters exceeded

Sorry but not clear...

Please provide the sample of the required report

1

Hi Vadim

I would like to have in the first row that you can see in the screen shot above Total Opex 3+ Shared Service Cost (a quote of 9) because the second column is the category Total Editorial and Production Cost Category, something like creating in the report a new account that is the sum of Total Opex + Shared Service

0
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Vadim Kalinin Dec 15, 2016 at 09:49 AM
0

You will have to create the new parent of Total Opex and Shared Service

May be in the new hierarchy...

Show 8 Share
10 |10000 characters needed characters left characters exceeded

I thought was possible to do something smarter.

Is there any EPM formula to do that or local member?

0

Common parent is a smart and recommended method!

Not smart:

- Use EPMRetrieveData in some local member to get the value of second member - slow!

- Separate report with Total Opex and Shared Service in page axis - also slow

1

thanks Vadim

The finance boss doesn't want to create a new parent in the account dimension

Which alternative solution do you recommend to me?

0

"The finance boss doesn't want to create a new parent in the account dimension" it's you job to explain him that this is the only correct way! You may create the second hierarchy in account dimension to have this parent.

You can also create a member with dimension member formula to sum Total Opex and Shared Service and use it in the report instead of hierarchy parent. Not perfect but will work.

1

I will create a dimension member formula

Thanks

Michele

0

But the answer is not accepted!

1
Show more comments