Vi. Pivot table

I. Pivot table

1. Create a PivotTable

Insert-PivotTable, and select OK. If the file format is [XLS], the created Pivot table is of the old version (the same as that of excel2003). If the file format is [XLSX], the created Pivot table is of the new version.

Set the new version to the old version of the pivot table: Right-click the pivot table -- Pivot Table options -- display -- classic Pivot Table Pattern

The Pivot table has four areas: Report filtering, column label, row label, and value.

650) This. width = 650; "src =" http://s3.51cto.com/wyfs02/M01/4D/6B/wKioL1RQ73fiscbcAADyWNZ3UqQ262.jpg "Title =" qq20151129213649.jpg "alt =" wkiol1rq73fiscbcaadywnz3uqq262.jpg "/>

650) This. width = 650; "src =" http://s3.51cto.com/wyfs02/M02/4D/6B/wKiom1RQ8BzxCKruAADpf6V8YQY822.jpg "Title =" qq20151129214627.jpg "alt =" wkiom1rq8bzxckruaadpf6v8yqy822.jpg "/>

650) This. width = 650; "src =" http://s3.51cto.com/wyfs02/M00/4D/6C/wKioL1RQ8IOw0UOrAACvzHpovCI149.jpg "Title =" qq20151129213748.jpg "alt =" wkiol1rq8iow0uoraacvzhpovci149.jpg "/>

2. Change the pivot table Summary method.

Double-click [Sum item:?], Perform [Value Field settings] to change the summary Method

You can also perform [field settings] on the row label to change the [Category summary].

650) This. width = 650; "src =" http://s3.51cto.com/wyfs02/M00/4D/6C/wKiom1RQ_l2SwDQPAAD7zUZlN74559.jpg "Title =" qq20151129224834.jpg "alt =" wkiom1rq_l2swdqpaad7zuzln74559.jpg "/>

3. summarize multiple columns of data

When summarizing multiple columns of data, place the data in the [value area] and drag the data to the [column label area].

You can edit the data display in the rewrite column in the [edit bar ].

Change the style of a PivotTable: select a PivotTable -- PivotTable tool -- Design -- PivotTable Style

650) This. width = 650; "src =" http://s3.51cto.com/wyfs02/M01/4D/6D/wKioL1RRAWiDsYMxAAEVaLvpgbA814.jpg "Title =" qq20151129230007.jpg "alt =" wkiol1rrawidsymxaaevalvpgba814.jpg "/>

4. Use calculation in a PivotTable

Vi. Pivot table