Hello, all I am very new to the board. I have a workbook (attached) that has minly four different data points and would like to use he running total future. Perhaps as a pivot table and than plot in chart. I tried re-arranging my data because the way running total works. Look at the rows 53-166. Currently, I produced Running Total but the problem I am runing into is that Running Total keeps going (duplicates the last value) even though there are no values in source data. For instance, look at the tab named 'RT_Sample' and you can see that starting week of 6/23 the data in Actuals column is same (115,031) and it copied down all the way to end. How can I get around this? All I am trying to do plot the data of Plan and Actuals for each product for each week. Any help would be greatly appreciated it.
