Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

group by quarter

Status
Not open for further replies.

skootsu

Programmer
Sep 27, 2005
21
US
Can anyone tell me how to make by report (shipped orders, last full year, grouped by product catagory, summed $$ by catagory) show by quarter? I am guessing I would need to some how create a group for quarters them group by the product code? I have to have only one report (it will be published in pdf)that shows Last years shipments broken down by quarter, then each catagories sum.
Q1(Machines$$/Parts$$/Service$$)
Q2(Machines$$/Parts$$/Service$$)
Q3(Machines$$/Parts$$/Service$$)
Q4(Machines$$/Parts$$/Service$$)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top