3 Replies Latest reply on Oct 26, 2016 11:00 AM by David Li

    Percent Difference from the Previous Year : without having the previous year displayed in the view

    Dawit Gelan

      In the workbook attached, I would like to create a view that only shows the year 2016 and calculates it's percent difference from the previous year (2015) without showing the Amount for 2015. Table calculations does not work because I filter out the year 2015 and it needs that value to compute the differences. I am looking for a LOD calculation that calculates the percent difference before the 'Year' filter is applied.

       

      Thanks!