# Pin rows & columns

Pinning rows and columns is very helpful when you have too many rows or columns in your report. You can use the pinning option to freeze them respectively at the top or left so that they are visible even when you scroll to another area of the report.

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

<figure><img src="https://github.com/lumelinc/PowerTableDocs/blob/main/.gitbook/assets/3.8.1%20Pin%20rows%20columns.png" alt=""><figcaption><p>Pinned rows and columns</p></figcaption></figure>

### 1. Pin rows

In the example below, we have 'Gin and Tonic' and 'Margaritas' on the third page of the report. But this is an important category that is being tracked, so we want it to be easily visible on the report.&#x20;

<figure><img src="/files/k29h0GCCLJ8j3g7UemFl" alt=""><figcaption><p>Rows to be pinned to the top</p></figcaption></figure>

a) Hover over the row and click on the 'Pin' icon.  'Gin and Tonic' and 'Margaritas' accessories is pinned to the top.

<figure><img src="/files/8u3wxRQRDOTvxlNLYykb" alt=""><figcaption><p>Rows Pinned to the top</p></figcaption></figure>

c) If you navigate to another page in the visual, you can see that the row is still pinned.

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

<figure><img src="https://github.com/lumelinc/PowerTableDocs/blob/main/.gitbook/assets/3.8.7%20pin%20row.png" alt=""><figcaption><p>Rows are pinned across the pages</p></figcaption></figure>

### 2. Pin columns

In this example below, we have data for revenue, units sold, COGS, and Gross Margin. We want to focus on last month's Gross Margin.

a) To do this, we can pin December Gross Margin. Hover over the column and click on the gripper. Click on the 'Pin column' option

<figure><img src="/files/zokY7rUsklRIeWJuypgl" alt=""><figcaption><p>Pin column option in the column grippe</p></figcaption></figure>

b) December's Gross Margin gets pinned to the left.

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

<figure><img src="https://github.com/lumelinc/PowerTableDocs/blob/main/.gitbook/assets/3.8.10%20pin%20column.png" alt=""><figcaption><p>Column pinned to the left</p></figcaption></figure>

### 3. Unpin

a) To unpin an individual row, click on the pinned icon either in the pinned section or in the original row, as shown below.

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

<figure><img src="https://github.com/lumelinc/PowerTableDocs/blob/main/.gitbook/assets/3.8.2%20Unpin%20rows.png" alt=""><figcaption><p>Unpin row</p></figcaption></figure>

b) To unpin an individual column, click on the pinned icon and select the Un-pin column option.

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

<figure><img src="https://github.com/lumelinc/PowerTableDocs/blob/main/.gitbook/assets/3.8.3%20Unpin%20column.png" alt=""><figcaption><p>Unpin column</p></figcaption></figure>

c) When there are multiple pinned rows and columns, you can quickly un-pin the rows and columns by using the corresponding ‘un-pin all’ option from the row/column gripper.

<figure><img src="/files/4n0FsNIIiZ80waz3lr0w" alt=""><figcaption></figcaption></figure>

<figure><img src="https://github.com/lumelinc/PowerTableDocs/blob/main/.gitbook/assets/3.8.4%20Unpin%20all.png" alt=""><figcaption><p>Unpin all option in rows is shown</p></figcaption></figure>


---

# Agent Instructions: 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://docs.fabricplan.com/planning/working-with-lumel-epm/3.-basic-interactions/pin-rows-and-columns.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.
