0 Replies Latest reply on Nov 1, 2018 12:15 PM by Aviv Meital

    All Current Year MTD Avg - Need help!

    Aviv Meital

      Hi folks,

       

      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.

       

      Example:

      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!