DEF, DEF_ADD, and DEF_SUB functions allow users to modify or control the calculation level of detail (granularity), specifying the granularity of indicator-based calculation.
Adding Calculation Indicator
DEF
Definess only dimensions in the function.
DEF_ADD
Adds the dimension of the analysis area and the dimension of the function.
The calculation is performed based on the dimension of the analysis area and the dimension specified in the DEF_ADD function.
DEF_SUB
Subtracts the dimension of the function from the dimension of the analysis area.
The calculation is performed based on the dimension of the analysis area with ignorance of the dimension specified in the DEF_SUB.
For example, you can use this function to view the average annual sales of delivered orders without viewing the sales of each order, even though data is grouped by order.
EARLIER
Used in DEF-type functions generally as a parameter for inter-row filtering calculation.
For tables, dimensions of the analysis area refer to fields dragged into Dimension.
For charts, dimensions of the analysis area refer to the dimension fields in Graphic Property and those dragged into the analysis area.
滑鼠選中內容，快速回饋問題
滑鼠選中存在疑惑的內容，即可快速回饋問題，我們將會跟進處理。
不再提示
10s後關閉
Submitted successfully
Network busy