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.