Multi-dimensional data, pagination

After using the Excel Pivot table to summarize and analyze big data, you can use the "Report Filter field" on a page to dynamically view and summarize analysis results in multiple dimensions. However, sometimes we also need to present the data analysis results on different pages. The procedure is as follows:

(1) In the Excel 2013 worksheet, move the cursor to the PivotTable, and then in the PivotTable groups on the analysis context Tab Of The PivotTable tool, click the lower triangle button next to the [Options] button. In the displayed drop-down list, run the [show report filter page] command to open the "show report filter page" dialog box.

(2) In the dialog box, select the report fields that need to be displayed by page. For example, select "region" and click "OK". The system automatically displays the data analysis results by region.

Multi-dimensional data, pagination