We have a custom defined week called week starting e.g. 200701 is the first week in 2007 through to 200752 (or 200753 depending on the year). an enhancement for variables call current week starting and last week starting has been created in BI. We use these variable extensively in Queries. I would like to use these variables and offsets to create selections like current week, last week, last 4 weeks, last quarter, last 6 months , year to date (based on week starting) last 52 weeks (rolling) ...
Is this possible?, I have created value help lists I dont know how to use the lists as a whole group rather than the individual weekstartings within the lists.??
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.