There are limitations and workarounds - this is a good doc to help you:
and this one:
Ok so MDX is the way to go on this one, huh? I was kinda hoping that that wasn't the answer but I guess I have to take a look at it now!
Thank you very much!