YTD,MTD

[rathnam_qv]

Hi all,

i have data from 2011 to till date, from that how to Calculate YTD,MTD values...provide me Set analysis Expressions for that please...

Thanks in advance!!!

Smiley

[tresesco]

Have a look here

[#3]

hi

try this hope this helps you

for ytd--

sum({<Date={">=$(=yearstart(max(Date)))<=$(=max(Date))"},year=,month=>}sales)

for mtd--

sum({<Date={">=$(=Monthstart(max(Date)))<=$(=MonthEnd(max(Date))),year=month=>}sales)

Regards

vishwaranjan