EPM report question: hidden rows based on another report

[Former Member]

Hi,

this is a two part question about the same Excel sheet containing 2 EPM reports that share the same row elements.

Report 1 (black) is the main report showing entity/intco in rows and auditid/account/flow in columns.

Report 2 (blue) is a different auditid/account/flow.

I would like to hide all rows for which report 1 does not contain data. even if report 2 does contain data. Is that possible?

So, in my screenshot row 296 should be hidden as it only contains data for report 2 but not for report 1.

Thanks,

Arnold

[former_member186338 · Accepted solution]

Hi Arnold,

Report1 has to be default report and you:

Then you add second report with shared row axis!

Vadim

[former_member186338 · Accepted solution]

P.S. Look here - tested approach:

[Former Member · Accepted solution]

Hi Vadim,

I am on EPM Add-In SP22 .NET4 and this doesn't work. I had it set up that way and tried with a blank sheet again, just in case but my report remains as shown in my screenshot above.

Thanks,

Arnold

[former_member186338 · Accepted solution]

Ups, you have to use EPM filter tab:

Original report:

Line 11 has to be removed (with 7 and 9):

Filtering Tab for Report 1:

Result:

Vadim