Is it possible to get the trendline in a way that it just considers the values that are already there e.g. when we have data from Jan. – Sep. only the data from Jan to Sep and not from Jan to December?
My Trendline is based on expression := sum(Sales)
Yes Amit, its possible
you have to use sum(if(sales)>0) kind of expression..
We can Show that.
Can you share sample data ?
Retrieving data ...