Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Try something like this:
=(Sum(Sales) - Above(Sum(Sales)))/Above(Sum(Sales))
Try something like this:
=(Sum(Sales) - Above(Sum(Sales)))/Above(Sum(Sales))
May be as attached:
Much simpler than I thought. Thank you!