Filtering with nested dimension

Hi Anaplan community,

I need help setting up a filtered view to only display list items with value in any of the time periods in the selected Fiscal Year. And by any, I mean Q1 or Q2 or Q3 or Q4 or FY. Because for a line iten such as Headcount - there could be a value in Q1, but the corresponding FY has a zero value (because the summary is set as closing balance.

My starting point

My Desired view

Accepted answers

All comments

gaurav

Hi @sosunkwo you can apply the filter on each line item at FY23>0 condition. Make Show items that match the following as ANY.

Starting Point:

Filter:

Desired View:

Similarly you can do this at more dimensions as well but make sure summary is ON for the line items and apply the filter at top level of each dimensions.

Cheers!

Quick Links

Can you help?

Unanswered questions

Update email id
Can anyone please explain how to update my registered email ID jn Anaplan.
Predefaulting A Feild in ANAPLAN
Hello Anaplan Community, I have a special requirement from a customer and would appreciate your input. Let me explain the situation: We have a hierarchy with three levels: Level 1, Level 2, and Level 3. Screen 1: Creation of Level 1 Items On this screen, the user selects a team. Based on their selection, an action runs to…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…