Insert comparative field

[#1]

Hello,

I'm having trouble creating the following situation:

In the attached file, if you have a table watching a table A1 and A2, must take the field values ​​"META" for table A2 considering the value of last "MES" ie when I select "AGO" (August), the table A1 should I bring values ​​AGO (August) and the field META (Goal) bring me the value of JUL (July) in order to know if the value I am quoting the current month is less than or greater than the value quoted in the previous month.

[Gysbert_Wassenaar · Accepted solution]

See attached qwv

[#3]

Thank G Wassenaar!

[#4]

G Wassenaar, is possible in the same situation when the value of the previous month is 0 it will bring the lowest value of the first record to find?

Example: August target value is July, but July is equal to 0, then it bring me the value of June.