Paul - Thanks for the quick response.
I made a mistake in my message. It was meant to be TW,LY - this week last year.
The issue is skipping over the month aspect (ie not having to reference month or sum at the month level since we only care about the week level).
I am trying to create code that will get the total sales for this year last week. However, the nature of the data means that the time (YMW) hiearchy is Year.Month.Week.
Therefore I was wondering if there is a way of creating an MDX query that will skip the middle level (month), since we don't...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.