Trendline based on Data

[amit_saini]

Hi Folks,

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)

Thanks,

AS

[SreeniJD]

Yes Amit, its possible

you have to use sum(if(sales)>0) kind of expression..

HTH,

Sreeni

[nagarjuna_kotha]

Yes,

We can Show that.

Can you share sample data ?