Rolling N Months Calculation

[#1]

Hello,

I have a table like this:

	Jan	Feb	Mar	Apr	May
Amount	120	232	302	322	382

When I select Apr, the Pivot Table only shows:

	Apr
Total = Sum(Amount)	322

How could I make Total to be sum of Feb's, Mar's and Apr's amount, i.e. rolling 3 months, and giving out 856, i.e. 232 + 302 + 322?

Please help and advise. Thank you.

[er_mohit]

See the attached file

[#3]

Hello,

Thanks for your help. However, is there a way I could hide the previous months? For example, if I select Apr and May, Feb and Mar would be hidden, however, Apr and May could still show the accumulated total. Is that possible? Please help and advise. Thank you.

[Gysbert_Wassenaar]

See this document for some solutions: Calculating rolling n-period totals, averages or other aggregations