Color records linked with a record of "special kin...

[Sylvain_Dionne]

Hello, I am looking a way to group by date

For each Job I have a CabQty, DoorQty and DrawerQty to do. The doors must be manufactured 2 weeks before Cab and drawers 1 week before Cab (see attached 1.png).
My goal is to have a view by ProdDate (see attached 2.png).
I used colors to show what is make when.
See attached 3.png that resume the summation
I hope I am clear enough, it's not easy to explain.
Thanks