July 1, 2010 at 12:11 am
Hi Experts,
I have a detailed date dim table trying to figure out a way to create a column that indicates 'Calendar Type' (i.e. determines whether the period [e.g. 200912, 201001 etc] is the current QTD or previous QTD)
e.g. for the current month of July 2010
20104 - previous QTD
20105 - previous QTD
20106 - previous QTD
20107 - current QTD
20108 - current QTD
20109 - current QTD
thanks for your help in advance
I have these in the view already.
Current MAT 201001
Current YTD 201001
Month 201001
Current MAT 201002
Current YTD 201002
Month 201002
Previous Month 201002
Current MAT 201003
Current Month 201003
Current YTD 201003
Month 201003
Month 201004
Month 201005
Month 201006
Month 201007
Month 201008
Month 201009
Month 201010
Month 201011
Month 201012
July 1, 2010 at 4:02 am
jay83091 (7/1/2010)
...e.g. for the current month of July 2010
20104 - previous QTD
20105 - previous QTD
20106 - previous QTD
20107 - current QTD
20108 - current QTD
20109 - current QTD
thanks for your help in advance
I have these in the view already.
Current MAT 201001
Current YTD 201001
Month 201001
Current MAT 201002
Current YTD 201002
Month 201002
Previous Month 201002
Current MAT 201003
Current Month 201003
Current YTD 201003
Month 201003
Month 201004
Month 201005
Month 201006
Month 201007
Month 201008
Month 201009
Month 201010
Month 201011
Month 201012
Sorry, but it is very unclear what you really want
In a sample you gave how would you mark 201003? Pre-previous?
what about 201010? Future QTD?
Then looking into your view, I can see that the same month (201002) is taken as Current MAT, Current YTD, Month and as Previous Month :w00t:
What do you really want. Please click the link in my signature to present your question in a bit more helpfull way.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply