Displaying subtotals and totals

Follow these steps to expand and shrink the data rows, and display only subtotals and combined total in the visual.

  1. Click the + icon in the year column.
    Clicking the plus sign in the 'year' column to expand the rows and columns
  2. The visual expands the data to show subtotals of each year, and combined total for both years.
    Displaying subtotals of each year and combined total for both years
  3. Click the two + (plus) icons in the state column.
    Cross tabulation visual without expansion enabled
  4. The visual expands the data to show population in each state, and the subtotals and combined population for both years.

    Notice that the subtotals and combined total appear at the bottom of expanded rows. To move the subtotals and totals over the rows, see Showing expansion totals above expansion rows.

    Displaying subtotals and totals at the bottom of expanded rows

To disable subtotals and combined total, make changes in the Field Properties menu by de-selecting the Expansion option.