robert.gerald.taylor (11/5/2013)
Couldn't you do this in a calculated member and use the DateDiff() function to get the number of years. Then use IIF() to put in groups?Just thinking out loud here.
HTH,
Rob
Thanks for responding Rob. I can certainly look into it. The first thing I thought was DateDiff. Because I'm using the selected date, which is the slice, I'm not really sure how I'd use Datediff. If you have a simple example, I'd really appreciate it. then I'd need to put this logic into a function to reuse. My MDX skills aren't the strongest.
I'll go away and look at IIF() for groups.