{"id":15443,"date":"2025-07-15T13:34:52","date_gmt":"2025-07-15T13:34:52","guid":{"rendered":"https:\/\/functiontranslator.com\/ozetverial\/"},"modified":"2021-02-25T16:27:49","modified_gmt":"2021-02-25T16:27:49","slug":"getpivotdata","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/getpivotdata\/","title":{"rendered":"\u00d6ZETVER\u0130AL"},"content":{"rendered":"

\u0130\u015flev GETPIVOTDATA, bilinen T\u00fcrk\u00e7e ad\u0131yla \u00d6ZETVER\u0130AL, Excel ve Google Sheets’te \u00f6zet tablolardan (pivot table) belirli verilere eri\u015fmek i\u00e7in kullan\u0131l\u0131r. Bu fonksiyon, \u00f6zet tablo yap\u0131s\u0131na do\u011frudan h\u00fccre adresi kullanmadan eri\u015fim sa\u011flar. B\u00f6ylece \u00f6zet tablonuzdaki de\u011fi\u015fiklikler, bu fonksiyonla yap\u0131lan sorgulardaki veri al\u0131m\u0131n\u0131 etkilemez.<\/p>\n

\u00d6ZETVER\u0130AL Fonksiyonunun S\u00f6zdizimi ve Kullan\u0131m\u0131<\/h2>\n

GETPIVOTDATA fonksiyonunun temel s\u00f6zdizimi a\u015fa\u011f\u0131daki gibidir:<\/p>\n

GETPIVOTDATA(data_field, pivot_table, [field1, item1], [field2, item2], ...)<\/code><\/pre>\n
    \n
  • data_field<\/b>: \u00d6zet tablodan al\u0131nacak verileri i\u00e7eren alan\u0131n ad\u0131d\u0131r ve bu ad t\u0131rnak i\u015fareti i\u00e7inde belirtilmelidir.<\/li>\n
  • pivot_table<\/b>: Fonksiyonun verileri \u00e7ekece\u011fi \u00f6zet tablo h\u00fccresini ifade eder. Genellikle \u00f6zet tablonun en \u00fcst sol h\u00fccresinin se\u00e7ilmesi \u00f6nerilir.<\/li>\n
  • field, item<\/b>: Bu iste\u011fe ba\u011fl\u0131 arg\u00fcmanlar, \u00f6zet tabloda hangi s\u00fctun veya sat\u0131rlar\u0131n ve \u00f6zel de\u011ferlerin hesaplamaya dahil edilece\u011fini tan\u0131mlar.<\/li>\n<\/ul>\n
    \u00d6ZETVER\u0130AL fonksiyonunu daha iyi anlamak i\u00e7in iki ayr\u0131 \u00f6rne\u011fi inceleyelim:<\/p>\n
    \u00d6rnek Uygulamalar<\/h2>\n
    1. \u00dcr\u00fcn Kategorisine G\u00f6re Sat\u0131\u015flar\u0131n Toplam\u0131n\u0131 Bulma:<\/b><\/p>\n
    Bir elektronik \u00fcr\u00fcnler sat\u0131\u015f verisi \u00fczerinden olu\u015fturulmu\u015f bir \u00f6zet tabloyu ele alal\u0131m. Bu \u00f6zet tabloda ‘\u00dcr\u00fcn Kategorisi’ ve ‘Sat\u0131\u015f Miktar\u0131’ bilgileri kullan\u0131lmaktad\u0131r.<\/p>\n
    =\u00d6ZETVER\u0130AL(\"Sat\u0131\u015f Miktar\u0131\", $A$3, \"\u00dcr\u00fcn Kategorisi\", \"Laptop\")<\/code><\/pre>\n
    Bu form\u00fcl, A3 h\u00fccresinde ba\u015flayan \u00f6zet tabloyu temel al\u0131r ve “Laptop” kategorisine ait toplam sat\u0131\u015f miktar\u0131n\u0131 hesaplar.<\/p>\n
    2. Belirli Bir Y\u0131lda ve B\u00f6lgedeki Toplam Sat\u0131\u015f Hacmini Hesaplama:<\/b><\/p>\n
    =\u00d6ZETVER\u0130AL(\"Toplam Sat\u0131\u015f\", $A$3, \"Y\u0131l\", 2023, \"B\u00f6lge\", \"Bat\u0131\")<\/code><\/pre>\n
    Bu \u00f6rnekte, 2023 y\u0131l\u0131nda “Bat\u0131” b\u00f6lgesinde ger\u00e7ekle\u015ftirilen toplam sat\u0131\u015f hacmini bulmak i\u00e7in kullan\u0131l\u0131r. “Y\u0131l” ve “B\u00f6lge”, \u00f6zet tablonun ilgili s\u00fctunlar\u0131n\u0131 i\u015faret eder.<\/p>\n
    GETPIVOTDATA, b\u00fcy\u00fck veri setleri \u00fczerinden raporlama yap\u0131l\u0131rken veri do\u011frulu\u011funu korumak i\u00e7in olduk\u00e7a faydal\u0131d\u0131r ve \u00f6zet veriler \u00fczerinde detayl\u0131 ve dinamik analizler yap\u0131lmas\u0131n\u0131 sa\u011flar.<\/p>\n","protected":false},"excerpt":{"rendered":"
    PivotTable raporunda depolanan verileri d\u00f6nd\u00fcr\u00fcr<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[579],"tags":[],"class_list":["post-15443","post","type-post","status-publish","format-standard","hentry","category-arama-ve-basvuru"],"acf":[],"yoast_head":"\nExcel'de GETPIVOTDATA (\u00d6ZETVER\u0130AL) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da GETPIVOTDATA (\u00d6ZETVER\u0130AL) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/functiontranslator.com\/tr\/getpivotdata\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de GETPIVOTDATA (\u00d6ZETVER\u0130AL) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da GETPIVOTDATA (\u00d6ZETVER\u0130AL) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/tr\/getpivotdata\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:52+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-25T16:27:49+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Excel'de GETPIVOTDATA (\u00d6ZETVER\u0130AL) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta name=\"twitter:label1\" content=\"Yazan:\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/getpivotdata\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/getpivotdata\/\",\"name\":\"Excel'de GETPIVOTDATA (\u00d6ZETVER\u0130AL) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:52+00:00\",\"dateModified\":\"2021-02-25T16:27:49+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da GETPIVOTDATA (\u00d6ZETVER\u0130AL) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/tr\/getpivotdata\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/getpivotdata\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/getpivotdata\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Excel i\u015flevleri\",\"item\":\"https:\/\/functiontranslator.com\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Arama ve ba\u015fvuru\",\"item\":\"https:\/\/functiontranslator.com\/tr\/arama-ve-basvuru\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"\u00d6ZETVER\u0130AL\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\",\"url\":\"https:\/\/functiontranslator.com\/no\/\",\"name\":\"Function Translator\",\"description\":\"Excel function translator\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/functiontranslator.com\/no\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"tr\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"caption\":\"glavadmin\"},\"sameAs\":[\"https:\/\/functiontranslator.com\"],\"url\":\"https:\/\/functiontranslator.com\/tr\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel'de GETPIVOTDATA (\u00d6ZETVER\u0130AL) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da GETPIVOTDATA (\u00d6ZETVER\u0130AL) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/functiontranslator.com\/tr\/getpivotdata\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de GETPIVOTDATA (\u00d6ZETVER\u0130AL) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da GETPIVOTDATA (\u00d6ZETVER\u0130AL) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.","og_url":"https:\/\/functiontranslator.com\/tr\/getpivotdata\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:52+00:00","article_modified_time":"2021-02-25T16:27:49+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de GETPIVOTDATA (\u00d6ZETVER\u0130AL) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","twitter_misc":{"Yazan:":"glavadmin","Tahmini okuma s\u00fcresi":"2 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/tr\/getpivotdata\/","url":"https:\/\/functiontranslator.com\/tr\/getpivotdata\/","name":"Excel'de GETPIVOTDATA (\u00d6ZETVER\u0130AL) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:52+00:00","dateModified":"2021-02-25T16:27:49+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da GETPIVOTDATA (\u00d6ZETVER\u0130AL) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/tr\/getpivotdata\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/getpivotdata\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/getpivotdata\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Excel i\u015flevleri","item":"https:\/\/functiontranslator.com\/tr\/"},{"@type":"ListItem","position":2,"name":"Arama ve ba\u015fvuru","item":"https:\/\/functiontranslator.com\/tr\/arama-ve-basvuru\/"},{"@type":"ListItem","position":3,"name":"\u00d6ZETVER\u0130AL"}]},{"@type":"WebSite","@id":"https:\/\/functiontranslator.com\/no\/#website","url":"https:\/\/functiontranslator.com\/no\/","name":"Function Translator","description":"Excel function translator","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/functiontranslator.com\/no\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"tr"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","caption":"glavadmin"},"sameAs":["https:\/\/functiontranslator.com"],"url":"https:\/\/functiontranslator.com\/tr\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15443","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/comments?post=15443"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15443\/revisions"}],"predecessor-version":[{"id":26711,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15443\/revisions\/26711"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15443"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15443"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15443"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}