Just for my understanding I want to know that why does it not take direct addition?
Why do we have to workaround using LODs?
One more doubt??
How can we display the same when we select both the regions???
It must display the value of NCA + SCA.
I know that we have to use similar LODs but it's confusing.
I just followed your example's guidance and I am still not sure about your final goal.
You are summing up the number after aggregating with "Avg" when you use normal calc, that shows simple average of both.
1st step: calculate avg of XXX at level AAA = CCC
2nd step calculate sum of CCC of each calendar range
Probably not necessarily to use LOD, but as described above, you are trying to make nested aggregation and LOD or table calc is anyways needed.