> ## Knowledge Base Index
> Fetch the complete knowledge base index at: https://help.assisty.ai/sitemap.xml
> Use this file to discover available pages before exploring further.
> Pure-Markdown content can be obtained by appending a '.md' suffix to the content URLs listed in the sitemap (without the trailing slash).

# How to apply the pivot columns to check inventory per location in report stock on hand by product variant

### Step 1: Go to the report "Stock on hand by product variant"
There are some ways to get the report "Stock on hand by product variant" in Assisty - AI Inventory Management:

###### Using a build-in dashboard
1. Go to the left menu and choose **Inventory tracking > Inventory On-hand**
![](https://storage.crisp.chat/users/helpdesk/website/4a116e5f64029800/image_ek9qle.png)
2. Click on the title of card **Stock on hand by Product Variant** or **View Details**
![](https://storage.crisp.chat/users/helpdesk/website/4a116e5f64029800/image_ab8rcn.png)

###### Using the search box
1. There are TWO ways to use the search box: on the left menu or in the **Report library**
2. Using keyword *stock on hand by variant* to search
![](https://storage.crisp.chat/users/helpdesk/website/4a116e5f64029800/image_106ijdb.png)

### Step 2: Add stock per location columns using the pivot column.
The idea is "I want to have the inventory on hand of a product at each location next to the total inventory on hand". Based on this, I will use the "pivot columns" feature to implement (**Pivot column** is a feature that allows to transform of data from row to column).
1. Click on **three dots menu** on the top right corner and choose **Add Pivot Columns**
![](https://storage.crisp.chat/users/helpdesk/website/4a116e5f64029800/image_13k68gv.png)
2. On the modal, please choose **Metric for pivot" is "Inventory Quantity" and **Column to transform** is **Store Location**
![](https://storage.crisp.chat/users/helpdesk/website/4a116e5f64029800/image_19a4vno.png)
3. After clicking to **Apply**, don't forget to manage the columns listing in the next modal (hide/show column or change the position by drag and drop), and below is the last result
![](https://storage.crisp.chat/users/helpdesk/website/4a116e5f64029800/image_vaxap2.png)