Hi, I want to create a report that looks like this:
Metric 1
============
2004 2005
A
Data is updated fortnightly (not exactly on the 15th and 30th of every month. updates take place on 13th or 14th or 15th or 16th of every month). Today I want sum(Metric 1) from Jan 1, 2005 to Jan 31, 2005 under column 2005 and sum(Metric 1) during the same period in 2004 under column 2004. On Feb 15th I might want sum(Metric 1) from Jan 1, 2005 to Feb 15, 2005 under column 2005 and sum(Metric 1) during the same period in 2004 under column 2004. and so on.
I know that I need to use a transformation. cud someone pls explain in detail as how to go about in creating this Year to Date transformation and the corresponding metric?
Thanks
Thukaram
Metric 1
============
2004 2005
A
Data is updated fortnightly (not exactly on the 15th and 30th of every month. updates take place on 13th or 14th or 15th or 16th of every month). Today I want sum(Metric 1) from Jan 1, 2005 to Jan 31, 2005 under column 2005 and sum(Metric 1) during the same period in 2004 under column 2004. On Feb 15th I might want sum(Metric 1) from Jan 1, 2005 to Feb 15, 2005 under column 2005 and sum(Metric 1) during the same period in 2004 under column 2004. and so on.
I know that I need to use a transformation. cud someone pls explain in detail as how to go about in creating this Year to Date transformation and the corresponding metric?
Thanks
Thukaram