1 Reply Latest reply on Feb 7, 2013 1:10 PM by Shawn Wallwork

    How to do an average line on data with a running sum

    Dan Kopp

      I have a worksheet (displayed as a line graph) that has an order count over relative time, that is broken out by a dimension, then made cumulative by using the table calculation "Running Total".  Now I want to add a new line to the graph that is the average of the other lines but can't get it to work. One complication, is that the number of lines per relative time period (column) changes, so the denominator in an average calculation (sum or order counts / number of order count dimensions) is different for each relative time period.

       

      Attached is the packaged workbook, any help is greatly appreciated.