How to find difference in the same column

[jun_9644]

hi, I have this data set and trying to achieve the "difference" in query. I'm trying to compare revenue between Qtr 1 and 2, Qtr 2 and 3 and Qtr 3 and 4 (hence, only 3 differences). Also, how should I link the data together as I would like to show the variance in a card on the dashboard when I filter eg. Outlet A and Qtr 1 and 2 (variance on the dashboard image is wrong). Also if variance is smaller than 5%, I would like the card to be blank. Thanks!

[lbendlin]