To create a pivot table that shows the last 12 months of data (i.e.
Filter is a helper column with a formula flagging the last 12 months.
The formula uses the AND, TODAY, and EOMONTH functionsas explained here.
Pivot table last 12 months
This example shows how to create a pivot table that displays the last 12 weeks of data on an ongoing basis.
