Thanks Pete, you were on it. I found that as part of another discussion, and haven't updated this. That worked somewhat, for some reason I get the UD2 Top member "Top_Dept" on every row though. I think it maybe due to the expansion setting or something.
Gotcha, yeah probably something to do with the way it's being called. You would almost have to make individual rows for each intersection for it to work, which would be too much work, unless if it's only a handful of possibilities. There may be a technical solution to do this somehow, but I haven't come across that before.
