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 you must complete the prompt window
before the target report is rendered.
-
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 list tables, if
the hidden data item is, for example, 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.