index()!=1첨부된 예제 통합 문서에서는 Superstore 샘플 데이터 집합을 사용하여 다음 지침을 설명합니다.
IF [Segment] = "Consumer" THEN [Profit] END
WINDOW_MIN( SUM([Corporate Sales ])) - WINDOW_MIN( SUM([Consumer Sales]))
Tableau Prep에서 측정값을 피벗합니다. 참고: 계산된 필드는 Tableau Desktop에서 피벗할 수 없으므로 Tableau Prep에서 피벗을 수행해야 합니다.
Tableau Desktop에서 뷰 만들기
IF MIN([Pivot1 Names]) = 'Sales' THEN SUM([Sales]) ELSEIF MIN([Pivot1 Names]) = 'Dummy Measure' THEN ZN(LOOKUP(SUM([Sales]),-1)) - (LOOKUP(SUM([Sales]),-3)) END
IF MIN([Pivot1 Names]) = 'Dummy Measure' THEN [New Measure Values] END
001458133
1853 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.