Year over Year Sales Growth

[colliers_sn]

Hi,

How would I create a set expression that would calculation sales growth over a series of years?

It would look like this.

Year	Sales	Growth
2016	10,000	0
2017	12,000	20%
2018	15,000	25%

Thanks for any help.

[sunny_talwar · Accepted solution]

Depending on the sorting, you can use one of these:

When Ascending Year

Sum(Sales)/Above(Sum(Sales)) - 1

When Descending Year

Sum(Sales)/Before(Sum(Sales)) - 1

[colliers_sn]

Is it possible to do something like

sum(sales)/sum({<Year= {Year -1}>} sales)

???

[sunny_talwar]

Yes, but only when Year is not your dimension. Because when year is your dimension, this will only work for the most recent year.

[colliers_sn]

Thank you for your insight.

[sunny_talwar]

No problem at all

[vikasmahajan]

Hi sunny,

This will work with company and year month dimesions ad well?

Vikas

[sunny_talwar]

It should... you just have to be careful of the sorting and use After/Before if the year is pivoted dimension

[vikasmahajan]

Thanks

vikas