subtotals

If you fill in all the Quantity and Price fields, you see that the subtotals and the total price are calculated correctly (see figure 16).

如果填写所有Quantity和Price字段，则会看到正确计算出的小计和总价（参见图16）。

For this reason, we added the option to turn on and off the display of subtotals of the selected field to the context menu.

基于这个原因，我们在菜单中增加了所选区域分类汇总显示开关选项。

The next example demonstrates that you can make each group stand out to make it easier to find subtotals in the report.

第二个例子表明：你可以突出显示每一组项目，使得小计部分在报告中显而易见。

If you want to create subtotals or show other summary information for subsets of a table, you create groups using an aggregate query.

如果要创建小计或显示表的子集的其他汇总信息，可使用聚合查询创建组。

If the contents of the selected column change, the subtotals are automatically recalculated.

如果被选列的内容发生改变，分类汇总也将自动重新计算。

You need to select at least one column for adding subtotals .

您必须选择至少一列作分类汇总。

In the Use function box, select the function that you want to use to calculate the subtotals.

在使用函数框里，选择要计算分类汇总的函数。

In the Calculate subtotals for box, select the columns containing the values that you want to subtotal.

在分类汇总计算框里，选择包含要分类汇总的值的列。

And now the PivotTable no longer contains the subtotals for Mountain Bikes and Road Bikes.

现在透视表不再包括山地自行车和公路自车的分类汇总项目。

To filter out duplicate process engineering shapes and report on components , click Subtotals .

要筛选出重复的工艺工程形状并针对组件进行报告，请单击“小计”。

In the Subtotals dialog, in the Group by box, select the column that you want to add the subtotals to.

在分类汇总对话框的分类依据框里选择要添加分类汇总的列。

You can retrieve the current contents of the shopping cart (with subtotals) at any time by using a SELECT query.

您可以使用一个SELECT查询随时检索购物车的当前内容（包含小计）。

Defines a set of groupings by which to calculate subtotals.

定义要计算小计的分组集。

Create different kind of subtotals to a list or database.

创建不同类型的分类汇总，保存到列表或数据库中。

Defines a set of measures by which to calculate subtotals.

定义要计算小计的度量值集。

Defines sets of subtotals to calculate for measures in a measure group.

定义多组要对度量值组中的度量值计算的小计。

Excel can then more easily detect and select the range when you sort, filter, or insert automatic subtotals.

在执行排序、筛选或插入自动汇总等操作时，这将有利于Excel检测和选择区域。

The ROLLUP operator is useful in generating reports that contain subtotals and totals.

在生成包含小计和合计的报表时，ROLLUP运算符很有用。

You can use more than one summary function simultaneously for subtotals.

您可以同时使用多个汇总函数来进行分类汇总。

A totals query calculates subtotals across groups of records; a Total row calculates grand totals for one or more columns (fields) of data.

总计查询计算多组记录的分类汇总；总计行计算一个或多个数据列（字段）的总计。