Skip to Content

Sum of the two EPM reports totals dynamicallay in single worksheet

Aug 08, 2017 at 08:57 PM


avatar image

Hi ,

I have created Two EPM reports(One top and one bottom) in single worksheet . They both are independet reports no page or row axis sharing.

I have local member in each report to calculate Totals. I used

=SUM(EPMALLMEMBERS) . this local member created as insert after row axis.

Now i have two two sub totals each from one report.

i want to show grandtotal after second report by adding two subtotals.

how do we sum the two subtotals since they both are coming from seprate reports. Subtotals positions is also will change depending on the data.

do we have any epm formuals or local execel formauls to make it dynamically.

any help can be appreciated. can anyone share your ideas on this.

Thanks for your help.



10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Vadim Kalinin Aug 09, 2017 at 07:40 AM

First of all please use your real name to ask questions - you are violating rule 2 of this forum.

Second - it's better to provide sample screenshot.

10 |10000 characters needed characters left characters exceeded