Active child under a Parent - Check only future periods
Hi - I have a hierarchy of two levels - L1 (Parent) and L2 (Child). I have a module with the L2 dimension where a boolean line item is input across time periods (past and future). As we roll into the future, only the future x number of periods (say, 8 ) is updated to check which child members are active under a parent.
My requirement is to check the active L1 list member only if at least one L2 member under the L1 member is active in any of the future 8 periods. If no L2 member is active in the future 8 periods, the L1 member is not considered as ACTIVE. I have used a count line item for active boolean periods and no time scale line item to check the total count of L2 members under a L1. In the line item with no time scale, I have used the formula Count Boolean[LOOKUP: 'L1', SELECT: TIME.All Periods]. But here, I want to check the TIME only for 8 periods in the future. How do I do that?
Regards - Guru