1 Reply Latest reply on Feb 5, 2016 11:40 AM by Daniel Vincent

    calculated field when dimension in column

    Brian Mandel

      I am trying to create a year over year percent difference calculation based when the dimension is in the column.

      So I'll year years in the column and the table will look like what's below:

       

                                         YEARS

      Subject          2012     2013     2014

      MATH               23         34          37

      HISTORY          9           7             8

      READING          54        61          58

       

      So what I'm looking to do is create a calculated field for a percent difference from 2014 compared with 2013.

       

      Appreciate the help!