Year to Date Restarting per Year

[#1]

Hi,

I'd like to be able to make year to date calculations *restarting per year* in one chart.

If you make a selection  per Year it works.

If you remove the selection it makes a year to date calculation for the whole chart, which is not what I want.

I like it to restart per year.

Can anyone help? I've tried set analysis, I've tried rangesum.

One requirement: I can't precalcua

Kind Regards,

Dion Verbeke

Sr. BI Consultant

[swuehl]

Try creating columns segments by using advanced aggregation, which will automaticall lead to a restart of your rangesum, if you do it like

=aggr(rangesum(above(sum(Numbers),0,rowno())),Year,YearMonth)

Hope this helps,

Stefan