reference line question

[amien]

i have a simple line chart:

dimension : Date

Expression : SUM(Value)

now i have another table which contains the following columns:

start date campaign, end date campaign, target

i want to use this table to plot a reference line i my chart.

this line should be plotted across the campaign start date and end date.

i tried this:

sum({<Date={">=$(=min([Start Date]))<=$(=min([End Date]))"}>}  [Target])

but gives me only 2 records (facts for 2 days) while i would expect 5 records:

target | value

100    | 0

100    | 0

100    | 10

100    | 20

100    | 0

[sujeetsingh]

Check the linking first

[amien]

!added example

[amien]

not sure what you mean .. but i added an example