How can we reflect the total sales or production from the starting date of a calendar year up to today in a chart?

[#1]

How can we reflect the total sales or production from the starting date of a calendar year up to today in a chart?

[tresesco]

Hi 3idiots(brilliant),

there are many ways. one of them : Sum({<Date=>} InYearToDate(Date,'vMaxDate',0)* - 1*Amount)

Where vMaxDate=Max(Date),or you can use Today() function instead.

Hope this would help.

regards,

tresesco