How do I suppress future accumulations in a line/bar chart?

[steveniow]

Hi,

I'm sure their must be an easy was of doing this but...

I am trying to compare activity that we want to happen against what we have done so far. I am accumlating the data for each days activity and using sum(activity) to calulate the results.

Unfortunately - by accumlating I am finding data that is now showing into the future. I have tried every thing I can thing of but cannot get rid of the future activity whilst maintaining the future forecast.

it currently looks like this... and I would like to get rid of all the blue bars from the point at which it flat lines.

[sunny_talwar]

May be restrict the sum(activity) using set analysis to show only data up till today.

[#3]

Try to use set analysis combine with rangesum and show AMT to month you need.

if (sum ( {$<[Year] = {$(#=Only(vYY))}, [Month] = {"<=$(#=Only(vMM))"}>} [AMT]),

rangesum ( sum ( {$<[Year] = {$(#=Only(vYY))}, [Month] = {"<=$(#=Only(vMM))"}>} [AMT]),

above("Actual")

))