Following conversation from WHILE loop implementation I thought to make a separate post showing how to create a
GroupBy() formula that bypasses the Outer CurrentValue restraint.
Warning: This uses hidden formula and thus can break at anytime. I also generally don’t recommend this pattern as the problem you want to solve generally can be solved differently in a separate table with recursive formula. (I used it to be able to construct a Gantt Chart).