Skip to Content
avatar image
Former Member

Sum of the two EPM reports totals dynamicallay in single worksheet

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.



Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • 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.

    Add comment
    10|10000 characters needed characters exceeded