5 Replies Latest reply on Mar 23, 2016 3:10 AM by renske.hercules.0

    Calculate Average from "Percent difference from.."Table Calculation/ Calculate AVG growth

    renske.hercules.0

      Hi all,

       

      Im trying to make a calculation that calculates the average growth. I have calculated an Average Share per Series in the column "AVG Share per week".In the next column it shows the share of the previous week. I did this to calculate the growth between the current and previous week. Now I face two problem:

       

      1) I want every week to week growth to start for every Show + Series + Channel

      2) I want to calculate the average growth per series. I calculated 2 examples (see image attached). So Show 1, Season 2, airing on BBC1, should have an average growth of -4.7%.

       

      I also attached a workbook to show you what im working with.

       

      Hope someone can help !!

       

      Thanks a lot!

       

      example.jpg