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")