Sort by row axis dimension in Multiple reports sharing same column axis

[Former Member]

Hi,

As per business requirements, i created 2 EPM reports with same row/column structure. (Difference between the reports is - Rows are filtered based on property and Columns share same axis. I Had to do this as i can't achieve requirement in a single report).

All look good. But, new requirement is that i need to sort by 1 row dimension combining both reports. I'm assuming this can't be achieved but wanted to get experts opinions here before i go back and say the same thing to my business users. Please provide suggestions. Below (Enclosed) is what i'm looking for.

screenshot.png

[former_member186338]

First - it's a bad idea to use "Insert File" instead of correct "Insert Image" making your post unreadable.

Second - for sure you can't sort lines of multiple reports - no way!

Third - your issue is here:

Difference between the reports is - Rows are filtered based on property and Columns share same axis. I Had to do this as i can't achieve requirement in a single report).

Please explain your requirements!