Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
i Know set analysis.but i want to how to use ytd,mtd,lytd,mytd, and where to use any particular senario for using this
i would be grate if u attach any qvd related to this .
Have a look at this
And this
We have similar work we do. This is how we do mtd and ytd. Our financial year is July to June. There are probably easier ways to do this, but maybe this helps
MTD
if(Month='Jul',sum(BudgetJul),
if(Month='Aug',sum(BudgetAug),
if(Month='Sep',sum(BudgetSept),
if(Month='Oct',sum(BudgetOct),
if(Month='Nov',sum(BudgetNov),
if(Month='Dec',sum(BudgetDec),
if(Month='Jan',sum(BudgetJan),
if(Month='Feb',sum(BudgetFeb),
if(Month='Mar',sum(BudgetMar),
if(Month='Apr',sum(BudgetApr),
if(Month='May',sum(BudgetMy),
if(Month='Jun',sum(BudgetJun),
))))))))))))
YTD
if(Month='Jul',sum(BudgetJul),
if(Month='Aug',sum(BudgetJul+BudgetAug),
if(Month='Sep',sum(BudgetJul+BudgetAug+BudgetSept),
if(Month='Oct',sum(BudgetJul+BudgetAug+BudgetSept+BudgetOct),
if(Month='Nov',sum(BudgetJul+BudgetAug+BudgetSept+BudgetOct+BudgetNov),
if(Month='Dec',sum(BudgetJul+BudgetAug+BudgetSept+BudgetOct+BudgetNov+BudgetDec),
if(Month='Jan',sum(BudgetJul+BudgetAug+BudgetSept+BudgetOct+BudgetNov+BudgetDec+BudgetJan),
if(Month='Feb',sum(BudgetJul+BudgetAug+BudgetSept+BudgetOct+BudgetNov+BudgetDec+BudgetJan+BudgetFeb),
if(Month='Mar',sum(BudgetJul+BudgetAug+BudgetSept+BudgetOct+BudgetNov+BudgetDec+BudgetJan+BudgetFeb+BudgetMar),
if(Month='Apr',sum(BudgetJul+BudgetAug+BudgetSept+BudgetOct+BudgetNov+BudgetDec+BudgetJan+BudgetFeb+BudgetMar+BudgetApr),
if(Month='May',sum(BudgetJul+BudgetAug+BudgetSept+BudgetOct+BudgetNov+BudgetDec+BudgetJan+BudgetFeb+BudgetMar+BudgetApr+BudgetMy),
if(Month='Jun',sum(BudgetJul+BudgetAug+BudgetSept+BudgetOct+BudgetNov+BudgetDec+BudgetJan+BudgetFeb+BudgetMar+BudgetApr+BudgetMay+BudgetJun),
))))))))))))
Could any one attach related qvd for this example
PFA
Have a look at this
thanku kN
is it same steps we will follow for lytd,mytd,qtd
Yes absolutely,
See the above links given by other members if you find any difficulty