# Column gripper #### 1. Sort You can use the **Sort** option to sort your data in ascending/descending order or apply an absolute sort. For hierarchical datasets, sorting is applied to the child rows for each level of the hierarchy.

In the provided example, both the Month and the Sum of Profit measures are sorted in ascending order.

#### 2. Insert The Insert option can be used for the following operations: * **Copy as data input** - Create a new data input field. The values will be copied from the selected measure. * **New data input** - Create a new empty data input field * **Insert formula** - Create a new field using a built-in formula Learn more about [data input](https://docs.inforiver.com/premium-table/working-with-premium-table/4.-adding-business-logic-and-formulae/insert-manual-input-rows) and [formula measures](https://docs.inforiver.com/premium-table/working-with-premium-table/4.-adding-business-logic-and-formulae/insert-calculated-columns).

#### 3. Pin column The pin column option allows you to tag important columns right at the beginning of your report, saving you the effort required to scroll back and forth.

In the example, the sum of discounts has been pinned to the beginning of the report.

You can also choose to unpin a particular field or unpin all fields.

#### 4. Stick measure to last In some cases, using field measures can cause an automatic reordering of columns in the report. You may want a particular field, for instance, a field with an embedded chart, to always retain its position at the end of the report. You can use the **Stick Measures to Last** option to assign one designated measure to the last position. The last position will be retained even if new fields are added to the visual.

#### 5. Hide Column You can use the **Hide Column** option to mask a particular column in your report. In the animation below, notice how the *Sales* measure has been hidden in the report. {% hint style="info" %} You can use the **Show All Columns** option to display hidden columns again. {% endhint %}

#### 6. Select header Use the **Select Header** option to apply custom formatting to a particular measure header.

#### 7. Number formatting You can use this option to directly set a custom scaling factor for a particular measure.

#### 8. Show (-ve) sign When this option is enabled, negative values are displayed within parentheses, and the negative sign (-) is removed.

#### 9. Column gripper The column gripper allows you to quickly rearrange columns using a simple drag-and-drop action. This makes it easy to reorder columns, group related data, and customize the layout of reports without modifying the underlying data model.