YTD LYTD

[rajni_batra]

i have a query need to show YTD IN ONE COLOUMN N IN OTHER COLOUMN NEED TO SHOW DATA OF LAST MONTH OF PREVIOUS YEAR.

HOW CAN I GET THIS?????

[#2]

Hi Rajni,

you can use Sum({$<year={$(=only(year))}>}sales)

this will give u ytd

for last month try this one

Sum({$<year={$(=only(year)-1)},month={$(=max(month)>}sales)... this will work if you click on any year in list box

[perumal_41]

Hi

Sum({$<year={$(=max(year))}>}sales)

Sum({$<year={$(=max(year)-1)},month={$(=max(month)>}sales)

i thing useful for u .

Regards

Perumal A