1 of 1 people found this helpful
If the years are dynamic and you want the latest two years then ZZ's post is perfect.
If they're fixed then it can be simpler:
IF Year([Order Date]) = 2014 THEN [Sales] END)
IF Year([Order Date]) = 2015 THEN [Sales] END
Growth Rate (% Difference)
(SUM([2015 Sales]) - SUM([2014 Sales])) / SUM([2014 Sales])
Thanks ZZ and Jonathan happy weekend