Skip to Main Content

Developer Community


For appeals, questions and feedback, please email

Filter entire report in Financial Reporting Web Studio

tx84Jan 31 2024


We have a hierarchy levels 1-7 and the user would like to exclude Hierarchy Level 7 but would like to include Hierarchy 1 to Hierarchy 6.

I tried POV but it either selects the parent which will bring all 1-7 levels or just level 7. Tried the prompt selection method but the problem is existing report create extra columns when level 1-6 are selected.

Is there a way to filter the entire report so that data from Level 7 and its data does not even reach the report.