Order Summary report
Use this report to review and analyze store performance.
Options: start date, end date
Sorted by: year, month
Grouped by: year, month, currency
Report Column Name | Table Name | Column Name |
---|---|---|
Year | ORDERITEMS | TIMESHIPPED |
Month | ORDERITEMS | TIMESHIPPED |
Total Product Charges | sum(ORDERITEMS.TOTALPRODUCT) | |
Total Tax on Products | sum(ORDERITEMS.TAXAMOUNT) | |
Total Shipping Charges | sum(ORDERITEMS.SHIPCHARGE) | |
Total Tax on Shipping | sum(ORDERITEMS.SHIPTAXAMOUNT) | |
Total Adjustments | sum(ORDERITEMS.TOTALADJUSTMENT) | |
Total Order Value | sum(ORDERITEMS.TOTALPRODUCT + ORDERITEMS.TAXAMOUNT + ORDERITEMS.SHIPCHARGE + ORDERITEMS.SHIPTAXAMOUNT + ORDERITEMS.TOTALADJUSTMENT) | |
Number of Orders | count (distinct ORDERS.ORDERS_ID) | |
Average Sales per Order | sum(ORDERITEMS.TOTALPRODUCT + ORDERITEMS.TAXAMOUNT + ORDERITEMS.SHIPCHARGE + ORDERITEMS.SHIPTAXAMOUNT + ORDERITEMS.TOTALADJUSTMENT) / count (distinct ORDERS.ORDERS_ID) | |
Currency | ORDERS | CURRENCY |