Target vs Achievement

[#1]

Dear All,

I'm stuck with this for a month now.

I've Sales table : SPid,Sales,Sale_date

Target Table: SPid,Yearly Target for 2012

Problem is i need to  create a graph as attached for 2012

Sales is present for 1999,2000,2012, ok we can get only those sales which are in 2012 by year(Sale_date)='2012'

Even if there's no sales in a year the target should be shown on the graph, i.e. for 2012 sales is only for Jan to May, still Target should be a full line till Dec

Plz help

Regards

[Jason_Michaelides]

Maybe tick the "Show All Values" checkbox in the dimension tab for Month?

[#3]

Hi,

I don't have the months for targets. Need to create them probably by some Master Calendar & then link it to the months of Sales.

Probly create a key of Salesid & some date component(say Month Year).

This is what i've thought but unable to implement. Not sure too whether this will work or not.

Regards

[#4]

Hi,

Alternative workaround is to use acummulative expression (on months). Go to dimensions tab and check show all values for month. Then the straight line will continue.

Second alternative is, you above function to get the previous row's values in case of zero. ie., if(sum(sales)=0,above(sum(sales)),sum(sales)).

Regards,

Kiran Rokkam.

[#5]

Hi,

These are the things which can be done when i've the months for targets. "Things of the future"

I repeat....I don't have the months just the yearly targets

Regards