troubleshooting Question

Grouping data by defined time periods

Avatar of Stevepaget
StevepagetFlag for United Kingdom of Great Britain and Northern Ireland asked on
Crystal Reports
2 Comments1 Solution304 ViewsLast Modified:

I have a report which shows the no of days between a quote being sent and an order being received. I have used a formula which subtracts quote reply date from order received date.

I want to group the data in the report so that i can see the orders that were recieved within 2 weeks of quoting, then the orders that were recieved between 2-4 weeks, then 4-6 weeks, then 7-10 weeks, then 10 plus.

I also want to try and display the data on a pie chart to show the percentage of orders which were recieved in each time period.

I am sure it should be fairly simple but i can't find a way of doing it.

Report attached for reference

Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros