Hiding Data Items

Here is some information about hiding data items in tables, graphs, and geographical maps:

Restrictions on hiding data items

Data items that are selected for group breaks are automatically hidden. You cannot assign the data items to different functions.

Consequences of hiding data items

If you hide the geographic hierarchy in a report section that contains a geographical map, then the geographical map becomes invalid.
If you hide a category that is used in a report-linking prompt, then the prompt association is removed. The report link still works, but the user must answer the prompts to display the target report.
If you hide a data item that is used in a conditional highlighting rule, then the conditional highlighting rule is removed from the table or graph. If you hide a time hierarchy, then any custom data items that are based on relative time are also hidden.
A crosstabulation table measure filter or ranking that is based on a category or hierarchy that is located on the outermost column or the outermost row is removed if the category or hierarchy is hidden. This is because the filter or ranking is tied to the location of the data item. If the data item is removed from that location, then the filter or ranking is also removed.
If you hide a data item that is used in a sort, then the list table or graph is re-sorted, but the sorting information is saved with the data item. Here are some additional details:
- If the hidden data item was the only sorted column, then the list table or graph is re-sorted to use its defaults as determined by the underlying data source. If you reassign the hidden data item to a function in the table or graph, the sort is restored.
- For example, for list tables, if the hidden data item is the first out of three sorted columns, then the table is re-sorted so that the second sorted data item becomes the first priority and the third sorted data item becomes the second priority. If you reassign the first sorted data item to the Columns function, then the reassigned data item becomes the third priority in the sort.