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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Sales split over 12 Month Period

Status
Not open for further replies.
Sep 21, 2003
1
GB
Crystal Reports 8.5 How do I split 12 months sales into 12 columns. The data is from SageLine50 and I just need 12 totals going across the page.
Please keep it simple.
 
1.) You may need to use a FORMULA to pull the Month out of the field Month ({TABLE.DATE TIME})

2.) INSERT a CROSS TAB with the Column on the MONTH formula and Summarized Field on the "Sum of Sales" - you don't need to set a row.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top