> For the complete documentation index, see [llms.txt](https://docs.inforiver.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.inforiver.com/premium-table/working-with-premium-table/3.-basic-interactions/context-menus/column-gripper.md).

# 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.

<figure><img src="/files/R8wwRjduwSyGL34lIgFS" alt=""><figcaption><p>Sort option</p></figcaption></figure>

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

<figure><img src="/files/CLgAj7M9jp1y6xF92F6C" alt=""><figcaption><p>Sorted data</p></figcaption></figure>

#### 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](/premium-table/working-with-premium-table/4.-adding-business-logic-and-formulae/insert-manual-input-rows.md) and [formula measures](/premium-table/working-with-premium-table/4.-adding-business-logic-and-formulae/insert-calculated-columns.md).

<figure><img src="/files/kPaQuNNS1h8TNqRNmInn" alt=""><figcaption><p>Insert option</p></figcaption></figure>

#### 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.

<figure><img src="/files/2AVH3oeBq4uiirUGoQcZ" alt=""><figcaption><p>Pin column option</p></figcaption></figure>

In the example, the sum of discounts has been pinned to the beginning of the report.&#x20;

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

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

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

#### 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.

<figure><img src="/files/JGEChIp9f503OytNTdHT" alt=""><figcaption><p>Stick measures to last</p></figcaption></figure>

#### 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.&#x20;

{% hint style="info" %}
You can use the **Show All Columns** option to display hidden columns again.
{% endhint %}

<figure><img src="/files/N4V1AFpNJtFpdi0keG6F" alt=""><figcaption><p>Hide columns</p></figcaption></figure>

#### 6. Select header

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

<figure><img src="/files/yXhULM4ePiqYqPmgdXYj" alt=""><figcaption><p>Select header</p></figcaption></figure>

#### 7. Number formatting

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

<figure><img src="/files/cVIaaT8LZKR5KTw6nsdC" alt=""><figcaption><p>Number formatting</p></figcaption></figure>

#### 8. Show (-ve) sign

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

<div><figure><img src="/files/TvQxr9cN3gHHsh0683cu" alt=""><figcaption><p>show (-ve) sign disabled</p></figcaption></figure> <figure><img src="/files/gaVcTqQWTrysyj2xC7CT" alt=""><figcaption><p>show (-ve) sign enabled</p></figcaption></figure></div>

#### 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.

<figure><img src="/files/X52f1TOSHwqeXGt38EnF" alt=""><figcaption><p>Column gripper</p></figcaption></figure>


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## 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, and the optional `goal` query parameter:

```
GET https://docs.inforiver.com/premium-table/working-with-premium-table/3.-basic-interactions/context-menus/column-gripper.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

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.