1. I have a table with the following field: Date, Order#, BO, Lines.
2. I want to sum up number of BO's and Line's over Order# and Date; I also want to take the percent sumBO/sumLines
3. I then want to take the average of sumBO/sumLines over all dates (ignoring Order#).
I was able to do all but the third line.
Can someone help.
Example Attached.
Here is the resulting table I would want:
| Date | Average(SumBO/SumLines) |
| 6/1/2013 | 21% |
| 6/2/2013 | 23% |
