在此步驟中配置所顯示資料的時間範圍。例如,如果值為 -5,則顯示日期控制項參數中所設定日期之前五個月中的資料。
此導出欄位將允許在日期控件參數控件中選擇日期,並根據日期範圍控件參數顯示資料。
IF [Order Date] <= [Date Control]
AND [Order Date] >= (DATEADD('month', [Date Range Control], [Date Control])) THEN "Keep"
ELSE "Remove"
END
附註:只要基礎資料支援該函數,就可以修改計算欄位和參數來顯示年度、季度等。
001458325
976 KB

We use three kinds of cookies on our websites: required, functional, and advertising. You can choose whether functional and advertising cookies apply. Click on the different cookie categories to find out more about each category and to change the default settings.
Privacy Statement
Required cookies are necessary for basic website functionality. Some examples include: session cookies needed to transmit the website, authentication cookies, and security cookies.
Functional cookies enhance functions, performance, and services on the website. Some examples include: cookies used to analyze site traffic, cookies used for market research, and cookies used to display advertising that is not directed to a particular individual.
Advertising cookies track activity across websites in order to understand a viewer’s interests, and direct them specific marketing. Some examples include: cookies used for remarketing, or interest-based advertising.