The Order Revenue by Department report provides a breakdown of order revenue across departments for events within a selected reporting period. Revenue is displayed in separate columns for each department, making it easy to compare departmental revenue across orders.
Description
This report lists order revenue for events within a selected date range, with revenue amounts broken down into separate columns for each department.
You can filter results by order status, customer type, event end dates, and order dates. The Group By option allows you to display the results together or organize them by event.
The report can be used to compare how revenue from individual orders is distributed among departments.
Report Example
Available Filters
Use the following filters to select the orders and events included in the report and customize how results are organized.
| Field Name | Available Values | Default |
|---|---|---|
| Status(es) | Payment Pending Confirmed Cancelled Closed |
Payment Pending Confirmed Closed |
| Customer Type(s) | Standard EAC Show Organizer |
All |
| Starting Event End Date | Beginning of the event end date range included in the report | Beginning of time |
| Ending Event End Date | End of the event end date range included in the report | End of time |
| Order Start Date | Beginning order date included in the report | Blank |
| Order End Date | Ending order date included in the report | Blank |
| Group By | None Event |
None |
Filter Details
Status(es): Determines which order statuses are included in the report. By default, Payment Pending, Confirmed, and Closed orders are included. Cancelled orders are excluded unless selected.
Starting Event End Date and Ending Event End Date: Define the range of event end dates used to select events for the report.
Order Start Date and Order End Date: Allow you to further limit results based on the dates orders were placed. Both fields are blank by default.
Group By: Select None to display results without event grouping, or Event to organize order revenue by event.
Tip: Select Event under Group By to compare departmental revenue across events. Use the order date filters to focus on revenue generated during a specific ordering period.
Sample Report
Open the Order Revenue by Department PDF to see an example of the finished report, including order revenue broken down by department.