Configuring a cross tabulation visual for expansion
Follow these steps to enable expansion for a cross tabulation visual.
In this example, we show how to enable expansion on the year
and
state
fields.
-
Start a new cross tabulation visual based on dataset
US State Populations Over Time
[data sourcemain.census_pop
]; See Creating a visual. -
Populate the shelves from the available Fields
(Dimensions, Measures) in the
Data menu.
-
Add
year
andstate
to the Row shelf. -
Add
population
to the Measures shelf. Ensure that the default aggregation issum(population)
. -
Add
year
to the Filters shelf, set it to 1990 and 2000, and click Apply. -
Similarly, add
state
to the Filters shelf, select values AK, AL, AR, and AZ, then click Apply.
-
Add
- Click Refresh Visual.
-
When the cross tabulation visual appears, it does not have subtotals and the
combined total in the rows and columns.
Next, let's enable these options.
-
On the Row shelf, click
year
. -
In the Filter Properties menu, click
Expansion, and then click Enable
Expansion. A green dot appears to the right of the option.
-
Similarly, click
state
on the Row shelf, and enable expansion on that field. - Click Refresh Visual to see the changes.
-
The visual appears with a + icon in the year and
state columns. This indicates that you can expand the data.
The sum(population) column shows the combined population for both years.