YTD

[#1]

HI all how do i calculate YTD by months.

Current iam using the below formula which has monthNo in it .I want it to be by month .

=sum({$<Year={$(=Max(Year))},[MOnthNo]={"<=$(=(Max([MonthNo])"},Month=>}Sales)

This will give me ytd but every time i need to selsct monthno , I want  the ytd to be displayed when i selsct month list box .

[Anonymous]

replace monthno --> Month field which is used for the display

[arulsettu]

hi

try like this

Sum({<Year=, Month=, Datefiled={">=$(=Num(YearStart(Max(Datefiled))))<=$(=Max(Datefiled))"}>} Sales)