> ## Documentation Index
> Fetch the complete documentation index at: https://help.vori.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Generate a report of the top-selling items per department

> Use the Item Sales report to see top-selling items by department across a selected date range.

### Opening the Item Sales report

1. In Back Office, select **Reports** on the lefthand menu.
2. Within the Reports dropdown, select the **Item Sales** report.

<img src="https://mintcdn.com/vori/_IH6Rx-AZai7FP3O/images/image-png-may-29-2025-07-15-44-1798-pm.webp?fit=max&auto=format&n=_IH6Rx-AZai7FP3O&q=85&s=8ebd383330f27d245aa726087d7f6de1" alt="" width="2878" height="924" data-path="images/image-png-may-29-2025-07-15-44-1798-pm.webp" />

### Setting a date range for the report

On the top left section of the Item Sales report, set the desired date range for the report.

<img src="https://mintcdn.com/vori/_IH6Rx-AZai7FP3O/images/image-png-may-29-2025-07-18-54-4215-pm.webp?fit=max&auto=format&n=_IH6Rx-AZai7FP3O&q=85&s=c03ba34d616d805e7477d6b656ff261c" alt="" width="2788" height="432" data-path="images/image-png-may-29-2025-07-18-54-4215-pm.webp" />

### Setting groupings for the report

Directly above the Item Sales table at the bottom of the report, make sure the following settings are made:

* **Group:** Department
* \*\*Sub-Group:\*\*Sub-Department

✏️ **Note -** This will organize items by department, and then group related sub-departments under each one. The list will be sorted alphabeticallyby department, then by sub-department within each department.

<img src="https://mintcdn.com/vori/_IH6Rx-AZai7FP3O/images/screenshot-2026-04-08-at-10.28.55-am.webp?fit=max&auto=format&n=_IH6Rx-AZai7FP3O&q=85&s=a6f3facf02ed851d3859d99d8c487ddd" alt="Screenshot 2026-04-08 at 10.28.55 AM" width="1115" height="352" data-path="images/screenshot-2026-04-08-at-10.28.55-am.webp" />

And select one of three options to determine how the products within the report are sorted

* **Sort Products By:**
  1. Item QTY: Sort the products within each sub-department in descending order with the highest item quantity sold at the top.
  2. Item Weight: Sort the products within each sub-department in descending order, placing the items with the highest total weight sold at the top.
  3. Net Sales: Sort the products within each sub-department in descending order, with the items that generated the highest total sales revenue listed at the top.

✏️ \*\*Note -\*\*Products with no sales data for the given date range are automatically excluded from the Item Sales report. To include these items in the report, select the **Unsold Items Excluded** toggle by the report groupings.

<img src="https://mintcdn.com/vori/_IH6Rx-AZai7FP3O/images/image-png-may-29-2025-07-46-37-5331-pm.webp?fit=max&auto=format&n=_IH6Rx-AZai7FP3O&q=85&s=274df0459f9a3ef909a9485ae13e8a02" alt="" width="2284" height="218" data-path="images/image-png-may-29-2025-07-46-37-5331-pm.webp" />

### Reviewing the report

After the report is generated and filtered, scroll to the **Item Sales** table at the bottom of the page.

* Click the **minus (-) sign** next to any **Sub-Department** name to collapse product rows into a single sales total for that sub-department.<img src="https://mintcdn.com/vori/_IH6Rx-AZai7FP3O/images/image-png-may-29-2025-08-16-32-6051-pm.webp?fit=max&auto=format&n=_IH6Rx-AZai7FP3O&q=85&s=7bc4e26633724cdb4bb058d30bb256bd" alt="" width="1010" height="312" data-path="images/image-png-may-29-2025-08-16-32-6051-pm.webp" />
* The same can be done at the **Department** level to view totals without sub-department or item-level detail.<img src="https://mintcdn.com/vori/_IH6Rx-AZai7FP3O/images/image-png-may-29-2025-08-17-16-1048-pm.webp?fit=max&auto=format&n=_IH6Rx-AZai7FP3O&q=85&s=c253570dce932635ddbfae79357d6207" alt="" width="780" height="318" data-path="images/image-png-may-29-2025-08-17-16-1048-pm.webp" />
* Hover over the **top-right corner** of the table and click the **expand icon** to enlarge the view and display all product details, including sales quantity, item weight, and net sales.<img src="https://mintcdn.com/vori/_IH6Rx-AZai7FP3O/images/image-png-may-29-2025-08-17-47-3412-pm.webp?fit=max&auto=format&n=_IH6Rx-AZai7FP3O&q=85&s=eac9abdffe9dffc8104bc9c25a88ded0" alt="" width="832" height="354" data-path="images/image-png-may-29-2025-08-17-47-3412-pm.webp" />


## Related topics

- [Frequently Asked Questions](/faqs.md)
- [Advanced Reporting: Filtering, Customizing, and Saving Report Views](/reporting/sales-and-product-performance/advanced-reporting-filtering-customizing-and-saving-report-views.md)
- [Review and Print the Till Report](/reporting/daily-and-shift-reports/review-and-print-the-till-report.md)
