Analyzing Data with PivotTables and PivotCharts 410 5. You can expand or collapse the rows or pivot the data so that Country is the row field and ExpenseType is the column field. Close the PivotTable, and then close the ExpenseViews form. If you check the Database window at this point, you'll see no form with the name Expen- ses_PivotTable. Because in this example the PivotTable form is only for viewing data, we don't need to save it in the database. As part of the Close event for the ExpenseViews form, we delete the form using the following code: