I am having challenge with BPC EPM report in which I need to have 2 reports with shared column axis with Local members. Shared local member for second report doesn't refer/point to second report row reference.
Please find the attached sample report structure where column axis is shared between Report1 and Report2. In Report1, the Variance formula start at C6-D6. Since the axis shared, the Variance formula in the second report is also starting from C6-D6 instead of C13-D13. How to correct the issue. Please advise.