Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

EPM report question: hidden rows based on another report

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

Tags:
replied

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

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question