[[["이해하기 쉬움","easyToUnderstand","thumb-up"],["문제가 해결됨","solvedMyProblem","thumb-up"],["기타","otherUp","thumb-up"]],[["이해하기 어려움","hardToUnderstand","thumb-down"],["잘못된 정보 또는 샘플 코드","incorrectInformationOrSampleCode","thumb-down"],["필요한 정보/샘플이 없음","missingTheInformationSamplesINeed","thumb-down"],["번역 문제","translationIssue","thumb-down"],["기타","otherDown","thumb-down"]],["최종 업데이트: 2025-07-30(UTC)"],[],[],null,["# pivot_index function\n\nThe `pivot_index` function can be used in [table calculations](/looker/docs/table-calculations) to extract and manipulate the value of a pivoted column based on its index (in other words, its position).\n\nSyntax\n------\n\n**`pivot_index(expression, pivot_index)`**\n\nThe `pivot_index` function evaluates `expression` in the context of the pivot column at the position `pivot_index` (1 for first pivot, 2 second pivot, etc.) The function returns null for unpivoted results.\n\nExamples\n--------\n\nThe following table shows a query that counts the number of orders made in each season of the year. The query includes a pivoted dimension, **Products Category** , which has the values `Swimwear` and `Coats`. To compute the total number of orders made in each season across all categories, create a **Total Orders Count** table calculation.\n\nThe **Total Orders Count** table calculation adds the value of the first pivot column to the value of the second pivot column. The formula is: \n\n pivot_index(${orders.count}, 1) + pivot_index(${orders.count}, 2)\n\nThings to know\n--------------\n\n`pivot_index` cannot be used in a [custom filter](/looker/docs/filtering-and-limiting#custom-filters)."]]
