How Excel sets up the auto-ingredient page report

Detailed operation steps:

① first downloaded a copy of the original data form on the Internet, we opened it with Excel2007, click the menu bar-Insert-PivotTable, Pop the Create PivotTable dialog, select the table area and place the position, OK.

② the PivotTable Field List on the right, drag the region and city to the report filter, drag the name to the column label, drag the category name to the row label, and drag the sum to the value.

③ Click the Pivot table and click the small triangle arrow next to the option to display the report filter page.

④ Select area, OK.

⑤ in this way, from the bottom of the label can be seen in the northeast, north, east, south, northwest and south-west regions of the data reports, a whole report is divided into pages.