You can use the
Combine
excluded rows into “All Other” property
for list tables or the
Combine excluded cells into “All
Other” property for some graphs. These properties combine content across categories (for
example, the content that is formed by combining the report object’s visible categories).
These properties are frequently used with filters and
ranks.
The effect of these
properties can be influenced by certain types of interactions. For
example, if you have a list table with a
Sales measure
data item, the list table might have the
Combine excluded
rows into “All Other” property selected and be targeted by a
slider showing a range of
Sales figures.
The category combinations that are dropped based on the range selected
in the slider control are grouped into a category named "All
Other."
Note: The Combine excluded
rows into “All Other” property is not available
for crosstabs. And, the Combine excluded cells into “All
Other” property is not available for time series
plots, bubble plots, scatter plots, step plots, geo maps, or word
clouds.
There is a similar, but distinct per-category “All Other” option that is provided
for
ranking in the designer.
For more information
about the All Other concept for ranking, see Add a New Rank.
The following list table
shows how the content of combining visible categories is factored
into “All Other”. The list table has two categories
and a measure. The
Combine excluded rows into “All
Other” property is selected on the
Properties tab. The list table is filtered by
aggregate quantity values using the adjacent slider control.
Here are some key points
about the
Combine excluded rows into “All Other” property
and the
Combine excluded cells into “All Other” property:
-
The property cannot be set when the report object is displaying
detail data.
-
The property cannot be set when the report object includes a
rank with the per-category
All
Other option selected.
-
The property cannot be set for
pie charts when the
Create “Other” slice
for minimal values property is selected.
-
The property cannot be set when
a hierarchy is assigned to the report object.
-
The property cannot be set for
line charts that are imported from the explorer.