March 25, 2002 at 8:00 am
Hey Guys,
Looking for a bit of help here. We have a huge table for all sales. Basically a user has requested an excel sheet broken down for each month (units sold & revenue) and also by country.
Has anyone produced a report like this? If so, could you give me a brief outline of how you achieved it?
Any idea's would be appreciated!!
Thanks
Clive
March 25, 2002 at 8:13 am
Could you post the DDL for the table? Usually either a group by, or maybe the cube/rollup options will give you something quick and dirty. If you need something really advanced might fall into OLAP territory. Once you have a table the summarized results you can export to Excel using DTS.
Andy
March 25, 2002 at 8:48 am
Hey Andy,
We have created a view which has all the data we need...However it's grouping it that is the problem! In the view we have...
Account Number
Account Name
Country
Part Number
Quantity Ordered
Sales Value
Date
MonthOfSale
YearOfSale
Not sure about the Cube/Rollup operator...I never really used it...
However, if the View is not enough, then I'll post the DDL for the tables.
Thanks,
Clive
March 25, 2002 at 8:48 am
Hey Andy,
We have created a view which has all the data we need...However it's grouping it that is the problem! In the view we have...
Account Number
Account Name
Country
Part Number
Quantity Ordered
Sales Value
Date
MonthOfSale
YearOfSale
Not sure about the Cube/Rollup operator...I never really used it...
However, if the View is not enough, then I'll post the DDL for the tables.
Thanks,
Clive
March 25, 2002 at 9:03 am
Hey all,
Just figured it myself...Need to get my brain in gear today! I just did not look at the view properly. We have all the data in there to group it by Country, Year & Month!
It's just going to be one of those weeks!!
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply