Hi alex - see the attached
this is the lats 3 month avg based on today
this is 6 month
and it produces this
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
Thanks for your response. That is almost what I am looking for but not quite, and that is because I should have clarified initially that I want to be able to filter the calculated field. In the picture I posted initially, you can see I have it filtered by region. If possible, I'm looking for 3 & 6 month average sales calculated fields that can be manipulated by filters.
Worked great, thanks!