Stop accumulation at a particular value

[Anonymous]

Hello All,

I have used full accumulation on my expression. However, I want the accumulation to stop at the month of Dec 2016 which is not the case. Is there someway to stop the accumulation or hide the values of 2017 using background colours or any other such option.

[antoniotiman]

Hi Joshua,

try this

RangeSum(Above(Sum({<Date={"<=01/01/2017"}>} Value),0,Rowno()))

Regards,

Antonio