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