From your calculation, Create BIN
Then to make LOD work properly, change the filter to context.
There are bunch of free training materials on the site.
If this helped, please mark my answer as correct / helped to close the thread, not from inbox but from original post.
help_BIN_SM_18.1.twbx 28.2 KB
Thank you very much, Shin!
This works wonders!
Could you elaborate on why this works on my question when I aggregate it, but when I split it by period it's not correct?
I'm still having difficulties understanding LOD expressions.
Anw, I marked your answer as correct, but sorry.. how do I close the thread?
You already successfully close the thread by marking correct.
why this works on my question when I aggregate it, but when I split it by period it's not correct?
==> Because the function of LOD itself is to disregard the dimension in the view and add own dimension which is in the LOD expression .