Subtotals

[统计] 小计

常用释义

[统计] 小计

扩展信息

小计

a) 小计(Subtotals): 但对于时间相关的价格条件不会生成小计b) 人为可调整的价格范围 c) 系统计算超载(Surcharges)与折扣(Disc…

子计

利用 WITH BY 语句创建子计(subtotals) ! 利用 WITH 语句建立最后的总计(totals) !

例句

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.

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

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.

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

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.

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

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 检测和选择区域。

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.

本节中的步骤介绍如何创建总计查询以计算多组数据的分类汇总。

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 的楷体。

更新时间：2025-06-07 20:54