I could really use some help with calculating the below requirement:
Interested in the calculation the Avg of all past MTD in the current year. Basically looking to measure how does our regional sales team are performing so far month in
comparison to the MTD avg of that region. I know how to calculate previous month MTD - but again, interested in the current year monthly avg.
Tomorrow is Nov 2nd 18 ==> MTD = 500
looking to get the Avg of past months for the first 2 days of the month.
Hugely appreciate any help here!
Retrieving data ...