Applying a TRUE boolean across all months when a single month is TRUE
I have a module with three relevant dimensions:
Position ID (FLAT Position ID)
Component (FLAT Components)
For a component under a position, if any month is marked true in an initial line item, every month should be marked true in an associated line item. Screenshot attached, but in the example if TBR for BELL is marked TRUE in JAN 21, I want to mark every month as TRUE in the next line item.
I have tried using an interim line item that removes the time dimension and then trying to pull it back up using an ANY, but this isn't working.
Any suggestions would be appreciated. Thank you