Skip to Content

Is it possible to connect axis for multiple reports across multiple spreadsheets?

Mar 24, 2017 at 03:26 PM


avatar image

Hi Everyone,

I have multiple reports on multiple spreadsheets that are exactly the same with the exception of the Department listed in the Page Axis. The report contains local members (are the same across all sheets.) I was wondering if it's possible to "connect" the row/column axis across all the reports?

For example, I want it so that if I update the TIME field (column axis) in one report, it will automatically update for all reports. This way I don't have to update every single one individually. However, the data still needs to be unique to the Department listed in the page axis.

Is this possible?

Thank you

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

1 Answer

Vadim Kalinin Mar 24, 2017 at 03:48 PM

How the column axis is defined? Is it related to context?

Show 2 Share
10 |10000 characters needed characters left characters exceeded

I'm not very familiar with the context, but I don't think so.

I never use the EPM context pane, and in the Report Editor I never select the first "context" members that appear.


Sorry, but it's absolutely not clear! Please describe your report in details with screenshots!