A number that specifies whether the row_fields, col_fields and values have headers and no matter whether discipline headers ought to be returned inside the results. The doable values are:

Sort by specifying requirements Use this technique to choose the column you need to kind, alongside one another with other conditions like font or cell colors.

To display subtotals above the subtotaled rows, pick out the Display subtotals at the top of every team Verify box. This selection is chosen by default.

By default, the worth while in the heading is not really A part of the sort operation. Often, you may need to turn the heading on or off so that the value while in the heading is or just isn't A part of the type Procedure. Do one of the next:

To make significant structure alterations to the PivotTable or its numerous fields, You may use certainly one of a few forms:

Click on and keep a subject title within the layout segment, then drag it outdoors the PivotTable Discipline Record.

If you are trying to add a similar area over at the time — for example for the Row Labels and the Column Labels regions inside the format part — the sphere is quickly eradicated from the first space and place in the new space.

Once you go a column to your row or simply a row to some column, get more info you are transposing the vertical or horizontal orientation of the field. This Procedure is also known as "pivoting" a row or column.

The Field Record includes a subject area where you choose the fields you want to show in your PivotTable, and also the Places portion (at The underside) in which you can prepare These fields the best way you wish.

知乎，让每一次点击都充满意义 —— 欢迎来到知乎，发现问题背后的世界。

To make significant structure modifications to your PivotTable or its numerous fields, You should utilize among a few sorts:

Use the sphere portion of the sector Checklist to include fields to your PivotTable, by examining the box next Buy from our website to subject names to put Those people fields from the default space of the sphere Checklist.

Activate or from the heading row It's always best to possess a heading row once you kind a column to make it a lot easier to grasp the meaning of the info.

To indicate expand/collapse buttons Decide on to indicate the broaden/collapse buttons for groups of columns with the same benefit. One example is, if your PivotTable has once-a-year sales info for just a set of products, You may have a bunch of columns for every worth of 12 months.