Reporting Requirement

Hi all,

i am working on queries.i hve to calculate a KF called Buiness outlook.The calculation like below..

Business Outlook is a calculated key figure in the current year. Previous months Invoiced Sales, current month to Month +2 / +5 / +11 Plan, Month 3/6 till end of year Sales Targets.

now the problem is, if the current month is NOV or Dec then we can't give Targets. we can't use next year's targets.

can anyone tell me how to calculate..

Thanks in Advance....

madhu