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
Start a new cross tabulation visual based on dataset
US State Populations Over Time[data source
main.census_pop]; See Creating a visual.
Populate the shelves from the available Fields
(Dimensions, Measures) in the
stateto the Row shelf.
populationto the Measures shelf. Ensure that the default aggregation is
yearto the Filters shelf, set it to 1990 and 2000, and click Apply.
stateto the Filters shelf, select values AK, AL, AR, and AZ, then click Apply.
- 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
In the Filter Properties menu, click
Expansion, and then click Enable
Expansion. A green dot appears to the right of the option.
stateon 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.