Calculating Week Over Week Difference by State

[KmbrlyPC]

I am needing to calculate the week over week change for a location. There are numerous locations and several weeks. Here is an example of some data and the desired result. Thank you for your help.

[raychase · Accepted solution]

Sort your data by state and date, then use a multi-row formula to perform [current row value] - [row - 1 value].

Workflow attached.

[KmbrlyPC]

It works perfect, thank you!