首页 > 生活美容 > 心理 > excel - measure函数

excel - measure函数

   来源:秀美库    阅读: 1.6W 次
字号:

用手机扫描二维码 在手机上继续观看

手机查看
excel measure函数

使用 GetMeasure 函数获取度量值仅适用于以下函数: Count、 Sum、 Average、 Max 和 Min。

例如,这些功能将正常工作:

Get CubeField0 = easure("[customer].[num_cars_owned]", xlCount, "NumCarsOwnedCount")

Set CubeField1 = easure("[customer].[num_cars_owned]", xlSum, "NumCarsOwnedSum")

Set CubeField2 = easure("[customer].[num_cars_owned]", xlAverage, "NumCarsOwnedAverage")

Set CubeField4 = easure("[customer].[num_cars_owned]", xlMax, "NumCarsOwnedMax")

Set CubeField5 = easure("[customer].[num_cars_owned]", xlMin, "NumCarsOwnedMin")

这些将不起作用:

Set CubeField3 = easure("[customer].[num_cars_owned]", xlCountNums, "NumCarsOwnedCountNums")

Set CubeField6 = easure("[customer].[num_cars_owned]", xlProduct, "NumCarsOwnedProduct")

Set CubeField7 = easure("[customer].[num_cars_owned]", xlStDev, "NumCarsOwnedStDev")

减肥
家居
健康
情感
婚姻
亲子
星座
宠物