Creating Filter to Show Lines with Sublines vs just Lines


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

Best Answer

  • Misbah
    Answer ✓



    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

    Miz Logix