Help with YTD, rangesum() and aggr()

[Enriquemmesteo]

Hello everybody,

currently I have this chart

the bars represent aggregated sales for the year. Currently I am using this as measure

RANGESUM(ABOVE(Sum([sales]),0,RowNo()))

currently I don't have sales value for future periods so the bars stop growing after this month ( X axis is my variable defined as "Time_Period").

I need the aggregation to start from zero again every 12 periods (every time the month of the period is 04)

thanks in advance!

[sunny_talwar]

Would you be able to share a sample app to help you with this?

[Enriquemmesteo]

Unfortunately I cannot, but I hope this example image illustrates what I want to achieve. What I want to do is what you see here on the third column, after 12 periods, the aggregated value resets.

Currently I have achieved it by using set condition and an if based on which fiscal period we are in...but I would like to see if the aggr or rangesum allow this kind of reset.