Creating Filter to Show Lines with Sublines vs just Lines

HarunT

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

Misbah

@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