> For the complete documentation index, see [llms.txt](https://kb.logicerp.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://kb.logicerp.com/logic-erp-installation-configuration-and-troubleshooting-solutions/faqs/reports/configure-item-group-wise-consolidated-sale-report.md).

# Configure Item Group wise consolidated Sale Report

**YouTube:** [How to configure Item Group-wise consolidated Sale Report?](https://youtu.be/nepWOFDdQEo)

## How to Configure Item Group wise consolidated Sale Report?

In this tutorial, we’ll learn how to configure **item groups or categories** in the **Sale Register Cross Tab Report** to analyze sales based on item classifications in **Logic ERP**.

***

### **Access the Sale Register Cross Tab Report**

* Go to the **Reports/Queries** section.
* Select **Sale Registers**.
* Open the **Sale Register - Cross Tab** report.
* Click on **Configuration** to open the setup window and define a new report configuration.

<figure><img src="/files/dDof70NaQbkl7oR6Labk" alt=""><figcaption></figcaption></figure>

***

### **Define Report Options**

* Under **Report Consolidation**, select **Item**.
* Within **Item Consolidation**, tick **Group** and move it to the **top** using the arrow keys.
* In the **Report Total** section, enable the **Grand Total** option to display overall totals.
* Under **Report Order**, move **Item** to the top using the arrow keys to prioritize the item sequence.

<figure><img src="/files/pbUzBzNoyHHnLNQXghvP" alt=""><figcaption></figcaption></figure>

***

### **Configure Transaction and Other Options**

* Go to the **Transaction Options** section.
* Enable the setting **Display Transaction Details**.
* Choose whether you want the report shown **by Value** or **by Quantity**.

<figure><img src="/files/xpyFqeEKATYiZTKKA4L3" alt=""><figcaption></figcaption></figure>

* In the **Other Options** section, configure any additional preferences as needed.

<figure><img src="/files/VgrMB15V3IBrxsUgWUcH" alt=""><figcaption></figcaption></figure>

***

### **Configure Group Options**

* Navigate to the **Group Options** section.
* Click on **Extra Item Groups** to open the list of available item group levels.

<figure><img src="/files/fKnLKy57yVls4hatsxKc" alt=""><figcaption></figcaption></figure>

* Select the **Category Group** or the desired group type.

<figure><img src="/files/lealjkKcOHNigdiOAksd" alt=""><figcaption></figcaption></figure>

* Save your selections once done.

***

### **Finalize and Customize Columns**

* From the available configurations list, select your newly created configuration and click **Create**.

<figure><img src="/files/Qjz6IX0OzkMelvvsKHlw" alt=""><figcaption></figcaption></figure>

* By default, all columns will appear in the report.
* To customize:
  * Click on **Setup Column Attributes**.
  * Select all columns first, then choose only the required ones.
  * Make sure to include the **Extra Item Groups** column — this is essential to display the category columns.
  * Rearrange column order using the arrow keys if needed.

<figure><img src="/files/Nnbu2drx9Kh2w9iSQSSC" alt=""><figcaption></figcaption></figure>

* Save the settings.

***

### **Generate and View the Report**

* Refresh the report by pressing **F2**.
* The report will now display **sales details by item category** within the defined date range.
* These results are based on the groups you configured earlier.

<figure><img src="/files/z4PLKombgDfGeLMWPDM4" alt=""><figcaption></figcaption></figure>

***

### **View Report Using Filters (Without Predefined Groups)**

* You can also generate the report without predefined groups.
* Click on the **Extra Item Group Filter**.

<figure><img src="/files/NwIw6i1wz3tYQzS7na0n" alt=""><figcaption></figcaption></figure>

* A complete list of all item groups will appear.

<figure><img src="/files/VvwjlPtL1DMJGbm8K4hI" alt=""><figcaption></figcaption></figure>

* Select any group to view consolidated sales — either **Quantity-wise** or **Net Value-wise**, depending on your preference.

***

**You have successfully configured and generated a sales report by item group or category in Logic ERP.**

<figure><img src="/files/7487NLthjIPZN6dGui1B" alt=""><figcaption></figcaption></figure>


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://kb.logicerp.com/logic-erp-installation-configuration-and-troubleshooting-solutions/faqs/reports/configure-item-group-wise-consolidated-sale-report.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.