Sales list year over year performance

04
Aug
2009
Sales list year over year performance

I'm having trouble coming up with a good way to model what seems like a fairly simple requirement: How is a sales list performing this month versus the same month last year. It sounds simple but there is a twist. If it was just a matter of stamping the sales list on each transaction and summarizing by month, that would be done. The twist is that the sales list comparison has to be made as the list is configured in the reported month and year.
About
This topic belongs to the forum
  • Data Warehousing and Business Intelligence based on dimensional modeling and the Kimball Lifecycle.

  • Numbers of topics : 1858
  • Numbers of messages : 8714
  • Numbers of users : 3801
  • Numbers of points : 1672
Similar topics
So it's apparently Elbow's official twenty year anniversary this month - I just wanted to say thank you for providing the soundtrack for the past 9 years of my life and creating five outstanding albums and many more B-sides that I can rarely go a day
Merry Christmas and happy New Year, Zoosiab Xyoo Tshiab
We have a need to compare monthly transaction amounts that are associated with 15 month fiscal years. A fiscal year 2009-10 would span July 2009 thru September 2010. But there can be transaction amounts in fiscal year 2010-11 associated with calendar
hi I am tring to write pl/sql procedure to create financial calendar seed date. I have confusion about ... how to code to get financial week /period/start and end date for calendar if financial year and quarter start at first monday of April. any idea or
"Six miles from Urfa, an ancient city in southeastern Turkey, Klaus Schmidt has made one of the most startling archaeological discoveries of our time: massive carved stones about 12,000 years old, crafted and arranged by prehistoric people who had not yet
Forums from same category
See also
more_less
Informations

3 Replies For the topic :
"Sales list year over year performance"

This topic has been viewed 970 times.

Last message :
04/08/2009 at 20h15 by "barclaywilliams"