subtotals
美 [ˈsʌbˌtoʊt(ə)l] 
英 [ˈsʌbˌtəʊt(ə)l]
词形变化
复数：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.
总计查询计算多组记录的分类汇总；总计行计算一个或多个数据列（字段）的总计。
A totals query calculates subtotals across groups of records.
总计查询计算多组记录的小计。
These two rows report the subtotals for the Color dimension.
这两行报告了Color维度的小计。
Groups do not have subtotals by default.
默认情况下，组没有小计。
You can easily add totals, subtotals, counts, and other elements that help you analyze the data.
您可以轻松添加总计、小计、计数和其他元素，以帮助分析数据。
Display subtotals of columns, such as the number of contract documents.
显示栏的小计，例如合同文档数。
The steps in this section explain how to create a totals query that calculates subtotals across groups of data.
本节中的步骤介绍如何创建总计查询以计算多组数据的分类汇总。
Below, we will be seamless steel tubes for automotive products like subtotals .
在下文中我们将会对汽车用无缝钢管产品进行一下分类汇总。
For example, you can define formatting for multiple levels of data, there are multiple levels of subtotals possible in a PivotTable, etc.
譬如，你可以在数据透视表中定义多种级别数据的格式，也可以设置尽可能的多种级别的分类汇总。
For example, you may decide to change the appearance of all subtotals in your spreadsheet to be 10 pt. Arial instead of 8 pt.
例如，您已经创建了一个长达15页的电子表格，您可能会决定将电子表格中出现的所有小计改变为10pt的宋体字而不是8pt的楷体。
Find the average, largest, and smallest beverage sales subtotals
查询饮料销售的平均值、最大值和最小值的分类汇总
Turn subtotals and grand totals on or off for the selected field in the PivotTable view
对数据透视表视图中的选定字段打开或关闭小计和总计
Subtotals displayed at the top of item groups
分类汇总显示在数据项分组顶部
Calculating subtotals and working with levels in Excel
在Excel中计算分类汇总并使用级别
summarize data in a list by using automatic subtotals
汇总清单数据使用自动分类汇总即可。
generates control - breaks and subtotals in the result set
在结果集中生成控制中断和小计。
This SELECT statement returns a result set that shows both the subtotals for each value of Item and the grand total for all values of Item
此SELECT语句返回的结果集既显示了Item中每个值的小计，也显示了Item中所有值的总计
