Average of prior months

ryan14

I have a detail which shows cities in the rows and months in the columns with sales for each location for each month. I would like to set up a 3 month average based on the month we are currently in, and give the file the ability to move forward automatically based on the month were in. I understand how to manually input an average, but am unable to figure out a solution to have it move forward each month when we change months.

kelsey_kincaid

Hi @ryan14 ,

A transpose tool would work well for this.  You can then sample the last 3 records (grouped by city), compute the average and then combine it back with the original data. I've mocked up a workflow below - let me know if this works for you or if you have additional questions.

3MoAvg.yxmd