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


      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!