Without knowing much detail, I assume their is a date column for all the children called something like "Start Date". Make a new LI which uses Rank to find the newest and break ties using sequential with something like: RANK("Start Date", ASCENDING, Sequential, TRUE, a Text LI which is the same for each group of Children). Then in another LI have an IF Statement so if the Rank = 1 you assign that product all the revenue. Note that Rank is something you should try to avoid if you can find another solution. You could try a Min on Start Date and then check to see if the parent start date equaled the child start date. in a another LI too if you aren't worried about 2 children having the same start date which would be more efficient.