YTD and MTD

[arulsettu]

hi

i need to display in straight table like this i used OrderNum as dimension

OrderNum      YTD      MTD    WTD

     1               ....          ...     ...

     2               ....          ...     ...

     3               ....          ....     ...

     4               ....          ....     ....

i used set analysis

Sum({<Year=, Month=, Quarter=, Week=, DateField=, DateNum={">=$(=Num(YearStart(Max(DateNum))))<=$(=Max(DateNum))"}>} Sales)

But i am getting zero result any help?

[#2]

Hi Arul,

do a search on the community and you will find many example of people asking about MTD and YTD, I suggest having a look first.

Two below from a quick search

YTQ, QTD, MTD and WTD

YTD MTD

Joe