2 Replies Latest reply on Mar 24, 2016 1:53 PM by venkatesh.sharma

    Highest/Max value within a measure over the past twelve months as the denominator for the current month

    Alexis Jasinski

      Help por favor!

       

      I am trying to take the highest value over the past 12 months and use it as the denominator for the current month. I would like it to effect only the current month and months going forward if applicable - not the previous months. Please see attached for an example!

       

      As you can see, the first month of October 2014 is 100% because it is the only month with a value. The next month is higher at 461, making November 2014 100% without changing the percentage of the previous month.