How do you calculate aggregates on calculated dimensions, pls?
I have created dynamic conditional dimensions; a user picks the first dimension and then has a subset to chose from for the second dimension. I have it working except for being able to calculate aggregates on the calculated dimensions - the first dimension calculates, but then the next does not; example attached. I believe this has something to do with the order variables are calculated, but I have tried many options to fix it and nothing has worked so far. Any suggestions would be much appreciated!