1 Reply Latest reply on Jul 5, 2018 5:43 PM by patrick.byrne.0

    Year on Year % increase

    Tom Bryson

      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.

       

      Tom