5 Replies Latest reply on Apr 8, 2018 8:10 AM by Geert Brouwer

    Creating 100-index from a selected period (grand total)

    Geert Brouwer

      Hi,

       

      Goal of the sheet is to bin/group the revenue on the movement based on a start and end period.

      So I know if the revenue if looked to the 2 selected periods is started, ended, little price increase (index), etc.

       

      So first I created several parameters to selected the start en end period for the comparison.

      This works fine...

       

      I only can't figure out how I can make the figures also as a 100-index.

      So as the starting point is FEB17... He creates 100-INDEX in FEB17 grand total. Al other fields/periods are now related to the grand total of FEB17.

       

      Screen Shot 2018-04-01 at 21.16.45.png

       

      I have search and tried several methods... only I don't see the solution.

      Who can help me?

       

      Kind regards,

      Geert