pivot table - rolling averages

[TXdore]

i have a table with financials: cost category, amount, month, year, cost code, ...

can pivot tables do rolling averages as in the annualized 12 month average, 9 month average, 6 month average, 3 month average?

[TXdore]

Something like this...but i wonder if it can be done it a pivot table so i can change rapidly between operations, budgets, years, etc.