LOOKUP 계산 끝의 숫자를 조정하여 계산의 차이를 늘립니다. SUM([Sales]) - LOOKUP(ZN(SUM([Sales])), -2)참고: -2는 "이전 셀 2개"로 계산됩니다. 데이터가 테이블로 표시된 경우 이는 현재 열에서 이전의 2개 열 수를 뺀 계산을 의미합니다. 뷰를 YEAR에서 QUARTER로 변경할 경우 이전 2개 연도에서 이전 2개 분기로 결과가 변경됩니다.
LAST() = 0
SUM([2015 Sales]) - SUM([2013 Sales])
001473029
1228 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.