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?