Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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