IBP - Supply & Response - Grouping of demand from different time buckets via demand prioritization

Hello Gurus,

I have a scenario, where I want to group demand from different time buckets - I did try demand prioritization but that didn't give the results which I anticipate. Please see below flavors of business scenarios with expected results -

Product P1, Color C1

Product P2, Color C2 ----> single resource R1

Product P3, Color C2

Example of demand and the way system should prioritize it, please see the image -