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.