1 of 1 people found this helpful
Hi Aaron - see Sheet4 of the attached workbook.
I created a couple fields to calculate rolling time period needed.
Then sum the records based on that field:
Then just take the AVG of these Rolling Records.
Hope that helps!!
First, you can tell the last date in the data source with a FIXED LOD. See [Last Date in Data] disoplayed on Sheet 3 in the attached.
And as for a rolling 3-, 6-, and 12-month calc, I have them displayed on Sheet 3.
Thanks Matt. This was exactly what I was looking for. I appreciate the quick response.
Thanks Joe. I didn't want the months in the view and I noticed when I removed the months I no longer got the average. Thank you for the assistance though.
Great! Happy to help!