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.
![](https://docs.inforiver.com/~gitbook/image?url=https%3A%2F%2F3062809325-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252FEbkCXCUXmtUq5tcnUtZE%252Fuploads%252FdNZZaCAeUuQqgJukTp3j%252F3.8.1%2520Pin%2520rows%2520columns.png%3Falt%3Dmedia%26token%3D50d4557a-f444-4155-969c-372ef33eab04&width=768&dpr=4&quality=100&sign=d1c6e1d7&sv=1)
1. Pin rows
In this example, we have Computer accessories on the second 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.
a) Hover over the row and click on the 'Pin' icon.
![](https://docs.inforiver.com/~gitbook/image?url=https%3A%2F%2F3062809325-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252FEbkCXCUXmtUq5tcnUtZE%252Fuploads%252FZ7D1vaFUPI98IUFJyddv%252F3.8.5%2520pin%2520row.png%3Falt%3Dmedia%26token%3D6ddf98d8-f8cd-4609-8b29-7ed28e40a33c&width=768&dpr=4&quality=100&sign=8477cef8&sv=1)
b) Computer accessories is pinned to the top.
![](https://docs.inforiver.com/~gitbook/image?url=https%3A%2F%2F3062809325-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252FEbkCXCUXmtUq5tcnUtZE%252Fuploads%252Fw6YFYgKG1ipYG7Ha3pg1%252F3.8.6%2520pin%2520row.png%3Falt%3Dmedia%26token%3D36112f6e-2f9e-463d-b8d2-874f8d5ff28d&width=768&dpr=4&quality=100&sign=6d3a94cd&sv=1)
c) If you navigate to another page in the visual, you can see that the row is still pinned.
![](https://docs.inforiver.com/~gitbook/image?url=https%3A%2F%2F3062809325-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252FEbkCXCUXmtUq5tcnUtZE%252Fuploads%252F7vx6vfIpBB7F7TtdePDu%252F3.8.7%2520pin%2520row.png%3Falt%3Dmedia%26token%3D2967e1cd-d03a-4e1c-8d53-5e27c57e1321&width=768&dpr=4&quality=100&sign=148ac84c&sv=1)
2. Pin columns
In this example, we have monthly data for sales, margin, and customers. We would like to focus on last month's sales.
a) To do this, we can pin December sales. Hover over the column and click on the gripper.
![](https://docs.inforiver.com/~gitbook/image?url=https%3A%2F%2F3062809325-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252FEbkCXCUXmtUq5tcnUtZE%252Fuploads%252FhcAEzwygrlOHUIxY4HP3%252F3.8.8%2520pin%2520column.png%3Falt%3Dmedia%26token%3Dee20b7a0-2835-4716-9614-046d239e7c07&width=768&dpr=4&quality=100&sign=bd579ba0&sv=1)
b) Click on the 'Pin column' option.
![](https://docs.inforiver.com/~gitbook/image?url=https%3A%2F%2F3062809325-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252FEbkCXCUXmtUq5tcnUtZE%252Fuploads%252FFkFT8ju0RHG6vK8YbA49%252F3.8.9%2520pin%2520column.png%3Falt%3Dmedia%26token%3Df7dbe2d2-617c-4457-9117-165ef87c6cd0&width=768&dpr=4&quality=100&sign=afaba050&sv=1)
c) December sales gets pinned to the left.
![](https://docs.inforiver.com/~gitbook/image?url=https%3A%2F%2F3062809325-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252FEbkCXCUXmtUq5tcnUtZE%252Fuploads%252F6IvrYQRk7GlxZZMciZlw%252F3.8.10%2520pin%2520column.png%3Falt%3Dmedia%26token%3Ddac5eb7f-a0b2-4d9d-a3fe-cec5ea8d6d59&width=768&dpr=4&quality=100&sign=4d1e3a4a&sv=1)
3. Unpin
a) To unpin an individual row, click on the pinned icon in either the pinned section or the original row as shown below.
![](https://docs.inforiver.com/~gitbook/image?url=https%3A%2F%2F3062809325-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252FEbkCXCUXmtUq5tcnUtZE%252Fuploads%252F4UNRGJRv2FarsXAypG2v%252F3.8.2%2520Unpin%2520rows.png%3Falt%3Dmedia%26token%3Def594b8b-8e6d-4a8a-9942-7dc4ea2be5ff&width=768&dpr=4&quality=100&sign=5a648d80&sv=1)
b) To unpin an individual column, you can click on the pinned icon in the pinned section. Or, click on the column gripper and the un-pin column option.
![](https://docs.inforiver.com/~gitbook/image?url=https%3A%2F%2F3062809325-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252FEbkCXCUXmtUq5tcnUtZE%252Fuploads%252FJ7HNl42dwv5W1KFf9C7J%252F3.8.3%2520Unpin%2520column.png%3Falt%3Dmedia%26token%3D7a13ae5f-119d-447f-a3c7-a94023ca900c&width=768&dpr=4&quality=100&sign=a152cb24&sv=1)
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.
![](https://docs.inforiver.com/~gitbook/image?url=https%3A%2F%2F3062809325-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252FEbkCXCUXmtUq5tcnUtZE%252Fuploads%252FQDp6NVHtydXHqJjLQLq0%252F3.8.4%2520Unpin%2520all.png%3Falt%3Dmedia%26token%3D3047d351-6e98-4618-a093-f562d8125cfe&width=768&dpr=4&quality=100&sign=bb93c374&sv=1)
In the next section, you can find a list of the available keyboard shortcuts.
Last updated