We're trying to show a forecast foward of 1% year on year from 2018 - 2028 (september) however we can't figure out how to apply the percentage. Example below
30 staff work in a store a and 40 staff work in store b (store a and b would be selected using a single option filter) We have the data (the 30 and 40 staff members at September 2018) we need to show on a line chart the number of staff in the next year with a 1% growth up to 2028 (so ten forcasted years). Further to this, we would like to add on a slider that would allow the end user to change the 1% growth up or down to see how that would look.
Any help and guidance greatly apprecaited.