Dimensionality
Dimensionality() 會傳回目前列的維度數。對於樞紐分析表而言,該函數會傳回有非彙總內容 (亦即不包含部分加總或摺疊彙總) 之維度資料行的總數。
語法:
Dimensionality ( )
傳回的資料類型: integer
限制:
This function is only available in charts. The number of dimensions in all rows, except the total which will be 0, will be returned. For all chart types, except pivot table it will return the number of dimensions in all rows except the total, which will be 0.
當任何圖表運算式使用了此圖表函數時,就不允許在圖表中依據 Y 值排序,或在表格中依據運算式資料行排序。因此,這些排序替代選項會自動停用。若您在視覺化或表格中使用此圖表函數,視覺化的排序將還原為對此函數的排序輸入。
範例:
A typical use for dimensionality is when you want to make a calculation only if there is a value present for a dimension.
| Example | Result |
|---|---|
|
For a table containing the dimension UnitSales, you might only want to indicate an invoice is sent: IF(Dimensionality()=3, "Invoiced"). |
- |