Thank you the replies
This case, the condition is not tight, and there were various ways of approach including which I did not imagine.
That's also fun and really educational, but had to summarize....
But will try my best
I will not cover all the approaches, but typical several approaches will be mentioned in this post and next post.
With this, becomes cumulative for entire period, not stop at year level. ==> NG!!
With this, nothing becomes cumulative.
Does it work if I explode to smallest level of "Day" ??
From here, sample of answers I got.
This works, but because of "Day" level granularity, it's not comfortable.
Here the condition is I use different calculated field to represent "year"
year(date) does not work though, because it's is different granularity level. I guess??
It's getting longer and I will post another approaches next time.
If you think this post is useful, please click "Like" top right or under each reply.
I will attach workbook next time.
As always: a very thorough, detailed and informative guide.