Replace crosstab table with PivotTable report ignoring criteria range.

用数据透视表报表替换交叉表，忽略条件范围。

youdao

For more complex data layouts, you can use the PivotTable system.

对于更加复杂的数据布局，您可以使用PivotTable系统。

youdao

To start with, imagine you were building the following PivotTable.

开始，想象一下你原来做下面这张表的时候。

youdao