Touble in displaying value at the end of timeline range selection

[sandipsatale]

I need to design Power View Report for which Date will act as "Timeline", so when I select DAte as "2010-10-01" to "2010-11-01" then It should show me report having data on "2010-11-01 because it is latest data value that I am having.

But as I have used "Sum" function, it shows me wrong result.
My actual meaning is that, on every date of selected window in timeline, value at the last day of selected window should be displayed at report. It should not use any other funtion


Can anyone help me to do db design and report formulation.