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