3 Replies Latest reply: Jun 5, 2018 12:07 PM by Brittany Cummings RSS

    Year over Year % Change

    Brittany Cummings

      I've been struggling to calculate % change between years/months so that it can change dynamically. I know how to hard code the years in, but want to see the % changes across multiple years. Here is an example of my data set:

       

         

      MonthYearValue
      120154
      220158
      320155
      420151
      520156
      620158
      720154
      820155
      920158
      1020157
      1120154
      1220155
      120165
      220164
      320168
      420162
      520166
      620164
      720161
      820165
      920166
      1020164
      1120162
      1220166
      120174
      220172
      320176
      420174
      520172
      620175
      720171
      820172
      920177
      1020176
      1120175
      1220175

       

      I currently have a pivot table on a sheet that looks like this using =Sum(Value)

       

         

      201720162015
      Value495365

       

      I'm trying to get to this without having to hard code the years into the set analysis formula:

         

      201720162015
      Value % Change-8%-23%0