Targets Mapping??

[rohitians]

Hello Everyone,

I have sales dashboard, the master calender is mapped on sales date...

but i am making a target report where in targets till march 2014 is der...but i aint able to take whole of target for analysis..

it takes up to as on today n not fro dec13 to mar 14...how do i tackle this problem....

Thanks and Regards.

Rohit Yadav

[#2]

Hi Rohit,

     Can you please mention here what you write in script?

Thanks,

Ashutosh

[rohitians]

SUM({$<FinancialYear=,MonthName=,Quarter=,FiscalYear={$(=max(FiscalYear))}

,[Posting Date]={">=$(=MonthStart(max({$<FiscalYear={$(=max(FiscalYear))}>}[Posting Date])))<=$(=max({$<FiscalYear={$(=max(FiscalYear))}>}[Posting Date]))"}

>}[Monthly Tar Val])/100000

this is for monthly....

if i take sum([Monthly Tar Val])/100000 den i am not getting whole of 2013-14 target..

[er_mohit]

you also make a master calendar for target report and mapped to target report  and concatenate it to sales master calendar

[kaushiknsolanki · Accepted solution]

Hi,

     Why dont you create a master calender fill the year of target and then link it to the sales data as well as target data.

Regards,

Kaushik Solanki