Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Have a look here
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