local members using multiple reports

[sap_user62]

Hi Friends,

I am trying to look for a way to add to local members of 2 different reports, other than using vba macro.

Local members of both the reports are the subtotal added to the rows, which works good.

The 3rd local member, would be the sum of these 2 local members

I could not use excel sum, as the reports have expansion, and excel references would not work good.

Thanks

Ed.

[former_member186338 · Accepted solution]

Sample screenshot required. In some cases it's possible to add hidden local member in the first row of first report with a fixed position...

Vadim

[sap_user62 · Accepted solution]

Thanks Vadim.

1st report

                                                                 Flow1  Flow2 Flow3

account(individual account#) Profit center

     15111300                          Total_PC            10       15     20      

     15111301                          Total_PC             30       35    40

                                            sub total1        =    40       50    60

2nd Report

                                                                 Flow1  Flow4 Flow7

account(individual account#) Profit center

     15111302                          Total_PC            100       15     200      

     15111303                          Total_PC             300       35    400

                                            sub total2       =    400       50    600

                                             Total                   440     100    660

Though the flows are different for report 1 and report 2 , they actually reflect to the same business terminologies wrt to the account.

[akos_beres · Accepted solution]

SAP user,

Local members are inherently Local to the report. Since you have two reports, I don't know of a way to reference them by name. If these are the only two section that you need to sum, try using an Excel formula either INDEX, SUMIF or your favorite reference function to come up with the total. (BTW this total doesn't have to be part of report 2)

The other option is combining the two reports into one ( try stacking right to left instead of top to bottom) and in that case you can create another local member that would add localmember1 and localmember2 together. (I realize this might not be an option based on reqs but it's worth a question)

Hope this helps!

Akos

[former_member186338 · Accepted solution]

In the first report add local member like:

The result will be fixed row with subtotal of the first report:

And you can reference it from the 3rd local member of the second report...

[sap_user62 · Accepted solution]

Thanks Akos, i could do an excel reference, but it report has expansions.

Thanks Vadim, It worked well.

[Former Member · Accepted solution]

Hello Vadim,

How can we reference a local member of a different report in our local mamber formula?

[sap_user62 · Accepted solution]

could you please start a fresh thread.

[former_member186338 · Accepted solution]

Yes, new discussion and detailed explanation with a sample and screenshot!