Calculate the YTD and MTD based on FinancialYear

[#1]

Dear All,

my financial Year starts from April and ends on March.

so i want to calcuate the YTD and MTD based on the financial Year

suppose if i select financial Year 2012 then the calculation should be start from April-2012 to max(Date).

like that if i select Financial year 2011 then calculation should start from April-2011 to March-2012.

find the attached sample.

Thanks,

Mukram.

[Gysbert_Wassenaar]

See attached qvw. Is that what you need?

[#3]

Dear Gysbert Wassenaar,.

Thanks for your reply.

but your solution is not full fulling my requirement.

Thanks,

Mukram.