3 Replies Latest reply: Sep 3, 2015 1:55 PM by saurabh singh RSS

    3 Year Rolling Average

    Zeth Baker

      I have used an expression to figure out the 3 year rolling average, but how do i show only the most recent for example. I only want to show the most recent rolling 3 year average so i only want to show the value for 2014, but when i try to hide the other years it effects the expression so the value is not the same. Any ideas?

      Year      Rolling

      2011       2906

      2012       1732

      2013       1876

      2014       1036