Skip to Content
author's profile photo Former Member
Former Member

EPM Report - Deducting Value from Total where node not in report


I need to create a report which provides a total at the bottom of the report - I have done this by putting the top node in the report. The problem is i also need to remove one node from the report and the total. To remove from the report i can used exclude members. This does not change the total.

See below the example table which contains two report (had to create two reports for specific reasons) and the hierarchy. The total should be the "top account" minus "Account D"



Options I have looked at:

1. Using a local member for the total but the node for Account D needs to be displayed. I also tried using EPMRetrieveData which did not work as expected as it didnt seem to take into account the column, i.e. JAN, FEB, MAR - it just returned the same value for each month

2. Another option is just to create another report elsewhere which contains details of the Account D and I just use that as a basis to deduce the value from the Top Account.

Any other options?

table.JPG (28.6 kB)
hierarchy.JPG (8.4 kB)
Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on Dec 05, 2014 at 12:09 PM

    Hi Leo,

    Use option - Calculate parents in Hierarchy.


    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Vadim Kalinin


      I have now one report - performance improvement.

      I am able to exclude data if needed by excluded members tab and the total still works with the "Calculate parents in Hierarchy" selected.

      PS: I used excluded members tab exclude children from second report.

      Thanks Vadim

  • Posted on Dec 05, 2014 at 12:08 PM

    Hi Leo,

    provide more details about row & page axis, nature of report i.e. Static or dynamic.

    Close the old thread If your query is resolved.



    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.