Isolating Top Level Parent in a Boolean

CMiddleton
New Contributor

Isolating Top Level Parent in a Boolean

I am having an issue that I'm not sure is able to be solved, but wanted to ask the community to see.

I have a hierarchy as follows:

Top Level = Total Company

BU L1 parent = Total Company

BU L2 parent = BU L1

 

In a boolean line item dimensioned by BU L2, I've tried a million ways to try and get the "Total Company" box to have a TRUE and the rest be FALSE. I can't use a lookup with a formula summary method, and not seeing a way around to accomplish the goal. I can have the Total Company appear TRUE while the BU L1 children are false when the line item is dimensioned by BU L1, but I cannot figure out a way to draw this down to the BU L2 level. Any ideas? 

1 ACCEPTED SOLUTION

Accepted Solutions
KirillKuznetsov
Certified Master Anaplanner

Re: Isolating Top Level Parent in a Boolean

Hi @CMiddleton 

Here is my solution

KirillKuznetsov_0-1639670883911.png

 

KirillKuznetsov_1-1639670887489.png

 

View solution in original post

2 REPLIES 2
KirillKuznetsov
Certified Master Anaplanner

Re: Isolating Top Level Parent in a Boolean

Hi @CMiddleton 

Here is my solution

KirillKuznetsov_0-1639670883911.png

 

KirillKuznetsov_1-1639670887489.png

 

CMiddleton
New Contributor

Re: Isolating Top Level Parent in a Boolean

Thank you, this worked a charm