how do I get the previous QTR value without date table

Input: Description Metric Target QTR Value 1. Strenth Of Services CS 0 QTR1 234 1. Strenth Of Services CS 0 QTR2 123 1. Strenth Of Services CS 0 QTR3 345 1. Strent...