Hide and Unhide Columns on Modeled Sheets

We add a new Download drop-down menu on your modeled sheets toolbar, enabling you to download either:

The printable view of your modeled sheet, which excludes all hidden values and respects your current view state, or
Your modeled sheet and include all hidden values and codes.

See Reference: Sheet Toolbar.

When you copy a row on modeled sheets and the row contains hidden columns, we now include the hidden column values when you paste the row.

We continue to skip hidden values when you copy and paste a range.

See Reference: Copy and Paste.

We add a new Hide Columns section on the Display Options menu in modeled sheets, enabling sheets users to select which columns to hide. You can deselect the Hide Column check box for columns on a modeled sheet to prevent sheet users from hiding the columns.

Also, we display carat icons with tooltips in the column headers to indicate hidden columns.

We also display the new Hide Columns section, carat icons, and tooltips in sheets on dashboards.

When you hide columns on sheets or sheets on dashboards:

We still enable you to filter the columns.
We don't include any hidden column values when you copy and paste a data range or copy rows.
If they're split columns and you copy the columns, we don't copy over the values from the hidden columns.
We now restrict you from splitting an entire row when you hide all splitable columns.

See Change Modeled Sheet View.

We add a new Allow Users to Hide Columns in Display Options check box that you can use for these column types on your modeled sheets in Model Management:

All Attributes.
All Dimensions.
All Display Columns.
Only the following Data Entry Columns: Text, Number, Date, Initial Balance, and Checkbox.

This enables your sheets users to hide or unhide the columns when they view the modeled sheets.

You can't enable users to hide these column types:

Level.
Text Selector.
Timespan.

You can only select the new check box when you deselect the Required Column check box. You can enable users to hide columns even if you also select the Read Only check box.

See Steps: Build Modeled Sheets.

We now enable you to configure a dashboards perspective with hidden columns, making it automatically display for all users you share the perspective with. Your users can still change their view state as well as hide or unhide columns.