1, data-existing links-using data sources to select tables and worksheets in excel.

2. Select the PivotTable report and properties.

3. Enter the selected SQL statement, in which the data is combined with the simple SQL statement.

Select "Zhengzhou", * from [Zhengzhou $] union all.

Select "Nanyang", * owned by [Nanyang $] Alliance.

Select "Xinxiang", * owned by [Xinxiang $] Alliance.

Select "Luoyang", * from [Luoyang $]

4. After confirmation, drag the fields in the same way as the previous PivotTable report with a single table.