Hi,
I have a Bar/Line Chart showing 'sales' information from 2016. For the series I am using Chart type Lines and a Lookup function Lookup(daterange, A:A, B:B).
Daterange has: 2160101,2160102, 2160103... 20161231.
How can I make the Line chart show a cumulative value instead of a day by day value?