Displaying subtotals and totals
Follow these steps to expand and shrink the data rows, and display only subtotals and combined total in the visual.
Click the + icon in the year column.
The visual expands the data to show subtotals of each year, and combined total
for both years.
Click the two + (plus) icons in the state column.
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.
To disable subtotals and combined total, make changes in the Field Properties menu by de-selecting the Expansion option.