Identifying data consecutive rows/columns in table

[G3S]

hi,

the table shown in the image has the data.  

requirement is to highlight where:

(1) Orders is greater than Allocation by 20% for more than  2 consecutive weeks (in the future)

Or

(2)  Orders is greater than forecast by 20% for more than  2 consecutive weeks (in the future)

like the values I've put a green box around. Can someone please help with the expression? Thanks in advance.

Allocation, Forecast and Orders are all derived through set analysis. 

[marcus_sommer · Accepted solution]

You could use interrecord-functions like above() and below() to access any cell-position within the chart.

Don't try to create the coloring-expression at ones else developing the logic step by step. This means adding n parallel expressions of:

above(MyExpression, 1)
above(MyExpression, 2)
...

and then implementing them into a condition like:

if(above(MyExpression, 1) - MyExpression >= X, true(), false())

and the last step would be to replace the true/false-results with the wanted colors.