---
title: "Separating Products by Category"
slug: "separating-products-by-category"
updated: 2024-10-21T10:38:03Z
published: 2024-10-21T10:38:03Z
canonical: "docs.avontus.com/separating-products-by-category"
---

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

# Separating Products by Category

You can list products, separated by category, on the Shipments Reports.

![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/9115bf02-36f2-4899-861f-b01a0cf3721b.png)

To do this **![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/b45d5e25-1671-476b-9488-1dd79faa7447.png)**

1. On the main window of the **Report** **Designer**, select **DetailProducts**
2. In the **Group and Sort** section, select remove to delete the current sorting. ![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/b1d1023c-1a17-41bb-a753-7b221e4efd44.png)
3. Click **Add a Group** and navigate to **ProductCategoryNameLazyLoaded![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/abc4fef0-abf1-4dda-8d81-0bbc7f1af9d7.png)**
4. Click **Add a Sort** and navigate to **ProductCategoryID** **![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/1ad07a2c-826a-4261-b670-3fa06ff83f22.png)** The **Group and Sort** section should look like this. ![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/4ad7ea56-08dd-4538-9e3d-7f5038822607.png)
5. In the **Field List**, expand **ShipmentProductProducts**

  

**![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/50196bdb-57fe-442f-b19b-1621497b71f1.png)**
6. Find **ProductCategoryNameLazyLoaded** and drag it to the design page. ![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/ec43a40e-850e-4a22-8aa5-cc17faf92d55.png)
7. You can then align the report, for example we can move the heading row of the **LblRentProducts** ![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/9fcfe885-8be0-4043-a530-a364815a2480.png)
8. You can then drag in the **Label** field**![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/460d29cd-93bf-4e9e-a840-6a8645c3ed45.png)**
9. Change the Label text to "Category" ![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/489e1d78-0af8-4679-88ab-3f72f77fd5e9.png)
10. Click **Save** in the top-left
11. Enter a name and click **OK![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/d8c4242e-b467-4aab-a6f3-047be712adcd.png)** You can then preview the report in Quantify to see your changes.**![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/80baf47a-0d05-4418-b1cd-2b341ab25460.png)** You can see this on the updated report. ![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/852ca1ab-44d9-41c6-ae73-88d56b99ff7e.png)