This content has been marked as final. Show 2 replies
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.