MTD for last year

[#1]

Can someone help me to make expression MTD for last year in pivot chart?

I also give the excel file for data to filter.

Thanks,

Danny

[martin59]

Hi,

I don't succeed to open your xls file.

But, if you want to do a Last Year MTD you have to use this kind of function :

InMonthToDate(DateField,Today(),-13)

Hope that helps you

Martin

[its_anandrjs]

Hi ,

You need to try to make a variable fields by creating two variables for latest month is

Let vNowMonth = Num(MakeDate(Month(Today(1)), Month(Today(1)), 1));

and for last month

Let vNowMonthLY = Num(MakeDate(Month(Today(1))-1, Month(Today(1)), 1));

Please try this code for your MTD creation.

And try to reattached your excel it will not open.

Regards,

Anand