Year on Year Growth - projection

[#1]

Hi,

It sounds simple but can somebody help me with the following. I am projecting and 10% growth (year on year) every year for the next five years. I want this growth to be a variable so that I can change it to 11%, 14% etc.

For example this is a table wit base sales of 100 on year1, you can see that if a 10%groth is applied the data is as follows

Year1	Year2	Year3	Year4	Year5
100	110	121	133.1	146.41

thanks

[martin59 · Accepted solution]

Hi,

You have to create a variable (Settings / Variable Overview / Add) named vGrowth and make a straight table with a dimension and this expression :

sum({<Year={Year1}>} MyField)

Rename this expression as : MyField Year1

Now you can do a second expression like this :

[MyField Year1]*vGrowth

Rename this second expression as : MyField Year2
Repeat this manipulation for the next expressions ([MyField Year2]*vGrowth...)

You can also do a slider to define your variable value.

Hope it helps you
Martin