Calculating Time Series Growth %

[#1]

I am trying to calculate QoQ growth % of sales through time and plot it in a manner similar to the chart below. I'm not sure if there is a way to do this through set analysis (all of my attempts have failed). I am able to calculate QoQ growth but only one period at a time

(sum({$<[Time Period]={"12-2015"}>}[Sales])-sum({$<[Time Period]={"09-2015"}>}[Sales]))/(sum({$<[Time Period]={"09-2015"}>}[Sales]))

.I've also tried  Not sure if it matters but each time period has ~2000 entries. Is there anyway to do this? Any help would be appreciated! Thanks in advance!

[sunny_talwar · Accepted solution]

Try something like this:

=(Sum(Sales) - Above(Sum(Sales)))/Above(Sum(Sales))

[sunny_talwar]

May be as attached:

[#4]

Much simpler than I thought. Thank you!