Dynamic Target (depending on month value and year)

[lessassy]

Hello everyone,

I have a bar chart which display KPI on a monthly basis from 2015 to 2018

Each year I have a monthly  and a weekly target for that KPI, which is for example:

2015: 200 monthly and 50 weekly

2016: 175 monthly and x weekly

2017: 175 monthly and so on

2018: 200 ....

SO i create a tab where i put very date of the year 2015 2016 2017 and 2018

And I put the kpi.

but 300 is a monthly KPI.

and i would like to display it on a combo chart.

But when i put (=Target' in combo chart reference line it doesn't work.

What function coul I used.

I tried Avg(Target) to have an average from a monthly target but i didn't get any response

I have a master calendar

Do you have a solution ?

Here are my sample files attached.

Thank you

[ogautier62]

Hi,

maybe you should link your monthly target to month calendar and not day;

also at a level day you can't give a monthly and a weekly target together

regards