2 Replies Latest reply on Aug 2, 2018 1:43 AM by Eoghan Lyons

    Nominal Difference in % Share n Periods Ago

    Eoghan Lyons

      Hi all,

       

      Bit of an unusual one here. I'm looking to see if there is a way to calculate the nominal difference in % share of a total compared to N periods ago.

       

      Example as per the attached workbook. Lets say the "Relative" tab. In this example Brand A makes up 16% of the total in Q1 17 and 30% in Q1 18. These calculations are done on the basis of a single point in time.

       

      Is there however, a way of calculating the nominal difference in overall share in different periods, for arguments sake let's say we want to see what the difference was between n and n-4 periods ago.

       

      Example:

      Q1 18: 30%

      Q1 17: 16%

       

      30%-16% = 14% nominal share gained.

       

      Many thanks,

      Eoghan.