Last Sales Date before current quarter by ID

[karan_kn]

We required to create Last Sales Date before current quarter based on ID, attached sample qvw. Please refer screenshot for better understanding the requirement. Thanks

Current Quarter (Feb, Mar, Apr 2019)