EPM report question: hidden rows based on another report
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.