Filtering with nested dimension

sosunkwo
sosunkwo
in Modeling

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

Starting Point.PNG

My Desired view

Desired View.PNG

Answers

  • gaurav
    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:

    image.png

    Filter:

    image.png

    Desired View:

    image.png

    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!

Categories