当前位置:婀娜女性网>美好生活>心理>

measure函数 excel

心理 阅读(1.66W)
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")