Column gripper

You can use the column gripper context menu to quickly sort or show/hide fields or insert a new field. Let's look at the various options in detail.

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.

Sort option

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

Sorted data

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 and formula measures.

Insert option

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.

Pin column option

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.

Stick measures to last

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.

You can use the Show All Columns option to display hidden columns again.

Hide columns

6. Select header

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

Select header

7. Number formatting

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

Number formatting

8. Show (-ve) sign

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

show (-ve) sign disabled

show (-ve) sign enabled

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.

Column gripper