# Displaying Sales by Warehouses and Items in the Gross Profit Report (BI)

> Source: https://help.getedara.com/en/articles/17181758-displaying-sales-by-warehouses-and-items-in-the-gross-profit-report-bi · Category: BI › Gross profit · Last updated: 2026-09-25 · العربية: https://help.getedara.com/ar/articles/17181758-%D8%A7%D8%B3%D8%AA%D8%B9%D8%B1%D8%A7%D8%B6-%D8%A7%D9%84%D9%85%D8%A8%D9%8A%D8%B9%D8%A7%D8%AA-%D8%AD%D8%B3%D8%A8-%D8%A7%D9%84%D9%85%D8%AE%D8%A7%D8%B2%D9%86-%D9%88%D8%A7%D9%84%D8%A3%D8%B5%D9%86%D8%A7%D9%81-%D9%81%D9%8A-%D8%AA%D9%82%D8%B1%D9%8A%D8%B1-%D8%A5%D8%AC%D9%85%D8%A7%D9%84%D9%8A-%D8%A7%D9%84%D8%B1%D8%A8%D8%AD-%D8%B0%D9%83%D8%A7%D8%A1-%D8%A7%D9%84%D8%A3%D8%B9%D9%85%D8%A7%D9%84

When analyzing sales performance, you may need to review the sales quantities and values of items within each warehouse in a single report, rather than navigating between multiple reports. Therefore, the “Stock vs Warehouse” table displays sales for both stock and service items, helping you easily compare warehouse performance and identify the best-selling items by quantity and value.

## Displaying Sales by Warehouses and Items in the Gross Profit Report (BI)

1. Go to the “BI” module.
2. Open the “Gross Profit” page.
3. Go to the “Data Pivots”.
4. Go to the “Stock vs Warehouse” section.
5. Select the required time period.

The table displays the “Sales Qty” and “Gross Sales” for each stock item within each warehouse, as well as the “Total Gross Sales” and “Total Sales Qty” for all warehouses.

![Displaying Sales by Warehouses and Items in the Gross Profit Report (BI) — The table displays the “Sales Qty” and “Gross…](https://help.getedara.com/images/bi/17181758/01.jpg)

> **Notes:**
>
> - You can search within the report using the search bar at the top of the page, or search a specific column using the search box located below the column name.
> - The results in the “Stock vs. Warehouse” table should not be compared directly with the sales report in Edara 2.0, because the Sales Report separates stock items and service items, while this table displays them together. This may cause differences in the total figures.

## Frequently asked questions

**Can I compare the Stock vs Warehouse results with the Sales Report?**

The results in the “Stock vs. Warehouse” table should not be compared directly with the sales report in Edara 2.0, because the Sales Report separates stock items and service items, while this table displays them together. This may cause differences in the total figures.