大家在查：峪大力削减 urgent message lunchroom 条江 moderate degree Activision 同样还 Storify 鈴

subtotals

美 [ˈsʌbˌtoʊt(ə)l]英 [ˈsʌbˌtəʊt(ə)l]

n.小计
v.求(…的)部分和[小计]
网络子计

复数：subtotals

subtotals

subtotals

英-汉英-英网络释义

subtotals

小计

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

子计

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

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 .

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

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 .

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

11

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

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

12

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

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

13

Defines a set of groupings by which to calculate subtotals .

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

14

Create different kind of subtotals to a list or database .

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

15

Defines a set of measures by which to calculate subtotals .

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

16

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

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

17

19

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

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

20

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

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

21

A totals query calculates subtotals across groups of records .

总计查询计算多组记录的小计。

22

These two rows report the subtotals for the Color dimension .

这两行报告了 Color 维度的小计。

23

Groups do not have subtotals by default .

默认情况下，组没有小计。

25

Display subtotals of columns , such as the number of contract documents .

显示栏的小计，例如合同文档数。

26

28

For example , you can define formatting for multiple levels of data , there are multiple levels of subtotals possible in a PivotTable, etc.

譬如，你可以在数据透视表中定义多种级别数据的格式，也可以设置尽可能的多种级别的分类汇总。

30

Find the average, largest, and smallest beverage sales subtotals

查询饮料销售的平均值、最大值和最小值的分类汇总

热词推荐

大家在看