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.

Pinned rows and columns

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.

Rows to be pinned to the top

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

Rows Pinned to the top

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

Rows are pinned across the pages

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

Pin column option in the column grippe

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

Column pinned to the left

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.

Unpin row

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

Unpin column

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.

Unpin all option in rows is shown