Pivot table - showing data being filtered off

Hi @lbl,
The February values (or rather January’s since it’s previous month), is not populating because the lag calculation is a table function; meaning it can only access the data that’s not filtered out.

Below is a really useful guide to order of operations within QuickSight as well as a further breakdown of various Period over period computations.

Check these out and let me know if you have any additional questions.