1.部分和,小计
1.求(...的)部分和[小计]
1.the total of part of a set of numbers but not of the whole set
1.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)。
2.For this reason, we added the option to turn on and off the display of subtotals of the selected field to the context menu.
基于这个原因,我们在菜单中增加了所选区域分类汇总显示开关选项。
3.The next example demonstrates that you can make each group stand out to make it easier to find subtotals in the report.
第二个例子表明:你可以突出显示每一组项目,使得小计部分在报告中显而易见。
4.If you want to create subtotals or show other summary information for subsets of a table, you create groups using an aggregate query.
如果要创建小计或显示表的子集的其他汇总信息,可使用聚合查询创建组。
5.If the contents of the selected column change, the subtotals are automatically recalculated.
如果被选列的内容发生改变,分类汇总也将自动重新计算。
6.You need to select at least one column for adding subtotals .
您必须选择至少一列作分类汇总。
7.In the Use function box, select the function that you want to use to calculate the subtotals.
在使用函数框里,选择要计算分类汇总的函数。
8.In the Calculate subtotals for box, select the columns containing the values that you want to subtotal.
在分类汇总计算框里,选择包含要分类汇总的值的列。
9.And now the PivotTable no longer contains the subtotals for Mountain Bikes and Road Bikes.
现在透视表不再包括山地自行车和公路自车的分类汇总项目。
10.To filter out duplicate process engineering shapes and report on components , click Subtotals .
要筛选出重复的工艺工程形状并针对组件进行报告,请单击“小计”。