Manage inserted rows & columns

Rows or columns inserted in the visual such as calculations, static rows, or data input columns can be managed using the 'Manage' options.

1. Manage rows

Inserted rows such as static, calculated etc. can be managed using the 'Manage' option highlighted below. A list of the inserted rows is displayed. The following operations can be performed:

a) Edit - Formulae or other properties can be modified

b) Delete - Inserted row can be permanently deleted

c) Show/hide row - Inserted rows can be hidden temporarily

d) Show/hide row indicator - The pencil icon next to the inserted rows can be hidden

Some changes have been made and the result is shown below.

2. Manage columns

Similar to the 'Manage rows' option, a list of inserted columns/measures is displayed along with options to edit, delete or hide them.

In addition, there is also a 'Insert new' option which lets you insert calculated columns or data input columns right from this panel.

Last updated