Help design an FR report with descendant function and suppression
Summary:
Dear Reporting Experts,
Need some help designing a report.
Following is the custom dimension hierarchy:
- RPT_Entities
RPT_Entity_1- RPT_Entity_2
- RPT_Entity_3
- RPT_Entity_4
- …
Following is the movement hierarchy:
- Total_Mov
Actual_Mov- Approval_Mov
We have created an FR Report with grid as follows:
Descendants of RPT_Entities | Descendants of Total_Mov (Inclusive)
Now we want to suppress "Actual_Mov" and "Approval_Mov" if "Total_Mov" is zero or nodata.
This needs to apply individually for each RPT Entity. Whats the best way to design this?
Version:
Service: Enterprise Performance Management Enterprise Cloud
Business Process: Financial Consolidation and Close
Tagged:
0