Hello,
I have a (probably) pretty easy question, but I can't quite figure it out. I have a couple of use cases where I need to allocate a value from a parent dimension (say: month) to the last dimension item of the child dimension (say: week). So in the case below I need to allocate 100 to week 48 2026 from the parent month dimension.
I did use a workaround using a ‘last week’ property (1's and 0's) in the week dimension and multiplying by that. But I feel like there should be a better solution available.
Can somebody help me out? :-)
Thanks!
Bas




