Creating Filter to Show Lines with Sublines vs just Lines

Options
HarunT
HarunT
in Modeling

Hello All, 

 

I am working on a budgeting model, and we have budget lines and sublines, and for dashboard, I just want to show budget lines when it has only one subline. Any advice on how to do that! Thanks

Tagged:

Best Answer

  • Misbah
    Misbah
    Answer ✓
    Options

    @HarunT 

     

    Create a line item called Count in Module 1, Type "1"in the formula

    In SYS module with  SUB LINE equivalent dimension, create following line items

     

    List Formatted -> Budget Line item => Parent(item(Sub line))

    Boolean Formatted -> Check?  => Module 1[LOOKUP: Budget Line] = 1 

     

     

    Apply Check? Filter in Module 1

     

    Hope that helps

    Misbah
    Miz Logix

Categories