Hiding data and subtotal rows To hide the expanded rows and subtotals, follow these steps. Click the - (minus) icon in the year and state columns. The expanded rows and subtotals no longer appear in the visual. Note that a (plus) icon appears again in the year and state columns. Parent topic: Displaying totals with data expansion