{"id":2085,"date":"2023-10-19T04:10:16","date_gmt":"2023-10-19T04:10:16","guid":{"rendered":"https:\/\/exceladvisor.org\/tr\/pivot-tabloda-hesaplama\/"},"modified":"2023-12-10T06:01:33","modified_gmt":"2023-12-10T06:01:33","slug":"pivot-tabloda-hesaplama","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/tr\/pivot-tabloda-hesaplama\/","title":{"rendered":"Excel&#39;de hesaplanan \u00f6\u011feler ve alanlar nas\u0131l kullan\u0131l\u0131r?"},"content":{"rendered":"<div class=\"excel-icerikten-once\" id=\"excel-2041094293\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div> <p><a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/tr\/pivot-tablo\/\" data-wpel-link=\"internal\">Geli\u015fmi\u015f bir pivot tablo<\/a> kullan\u0131c\u0131s\u0131 olman\u0131n ve veri analizi i\u00e7in Excel&#8217;i kullanman\u0131n en iyi yollar\u0131ndan biri, bir pivot tablodaki hesaplanan \u00f6\u011feleri ve hesaplanan alanlar\u0131 kullanmakt\u0131r.<\/p><p> Pivot tablodaki form\u00fclleri veya kaynak verilerde bulunmayan ancak di\u011fer alanlar gibi \u00e7al\u0131\u015fan \u00f6zel hesaplamalar\u0131 kullan\u0131n.<\/p><p> Basit bir ifadeyle bunlar pivot tablodaki hesaplamalard\u0131r. A\u015fa\u011f\u0131daki \u00f6rnekte, ortalama sat\u0131\u015f fiyat\u0131n\u0131 hesaplayan, hesaplanan alan\u0131n bulundu\u011fu bir pivot tablo g\u00f6rebilirsiniz. \u00d6te yandan kaynak verilerde buna benzer herhangi bir alan t\u00fcr\u00fc bulunmamaktad\u0131r. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" title=\"pivot tablodaki hesaplamay\u0131 ekle\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/inserer-le-calcul-dans-le-tableau-croise-dynamique-10.png\" sizes=\"\" srcset=\"\" alt=\"insert calculation in pivot table\"><\/figure><\/div><p class=\"qt-tip\"> Pivot tablolar <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/tr\/excel-becerileri\/\">ORTA EXCEL BECER\u0130LER\u0130N\u0130N<\/a> bir par\u00e7as\u0131d\u0131r.<\/p><h2 class=\"wp-block-heading\"> Pivot tabloda hesaplanan alan<\/h2><p> Excel PivotTable&#8217;da hesaplanan alan PivotTable&#8217;\u0131n\u0131zdaki di\u011fer t\u00fcm alanlar gibidir ancak bunlar kaynak verilerde mevcut de\u011fildir. Ancak pivot tablodaki form\u00fcller kullan\u0131larak olu\u015fturulurlar. Hesaplanan alan\u0131 bir pivot tabloya eklemek i\u00e7in bu basit ad\u0131mlar\u0131 izleyin.<\/p><ol><li> \u00d6ncelikle hesaplanm\u0131\u015f bir alan eklemek i\u00e7in basit bir pivot tabloya ihtiyac\u0131n\u0131z vard\u0131r. <br><img decoding=\"async\" title=\"\u00d6zet Tablo-2'ye Hesaplama Ekle\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Inserer-le-calcul-dans-le-tableau-croise-dynamique-2-1.png\" sizes=\"\" srcset=\"\" alt=\"Use A Simple Data Table To Add Calculated Field To Insert Calculation In Pivot Table\"><\/li><li> Pivot tablonuzdaki alanlardan birine t\u0131klaman\u0131z yeterlidir. \u015eeritinizde ayr\u0131ca iki se\u00e7ene\u011fe <strong>(Analiz ve Tasar\u0131m)<\/strong> sahip bir pivot tablo se\u00e7ene\u011fi g\u00f6receksiniz. Analiz se\u00e7ene\u011fine t\u0131klay\u0131n ve ard\u0131ndan <strong>Alanlar, \u00d6\u011feler ve K\u00fcmeler&#8217;e<\/strong> t\u0131klay\u0131n. Ayr\u0131ca se\u00e7eneklerin bir listesini alacaks\u0131n\u0131z, hesaplanan alana t\u0131klaman\u0131z yeterli. <br><img decoding=\"async\" title=\"\u00d6zet Tablo-3'e Hesaplama Ekle\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Inserer-le-calcul-dans-le-tableau-croise-dynamique-3-1.png\" sizes=\"\" srcset=\"\" alt=\"Insert Calculated Field To Add Calculation In Pivot Table\"><\/li><li> Hesaplanan alana t\u0131klad\u0131ktan sonra a\u015fa\u011f\u0131daki gibi bir i\u00e7erik men\u00fcs\u00fc g\u00f6receksiniz. Bu i\u00e7erik men\u00fcs\u00fc iki giri\u015f se\u00e7ene\u011fi (isim ve form\u00fcl) ve bir se\u00e7im se\u00e7ene\u011fiyle birlikte gelir. <br><img decoding=\"async\" title=\"\u00d6zet Tablo-4'e Hesaplama Ekle\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Inserer-le-calcul-dans-le-tableau-croise-dynamique-4-1.png\" sizes=\"\" srcset=\"\" alt=\"Calculated Field Pop-Up Box To Insert Calculation In Pivot Table\"><\/li><li> <strong data-rich-text-format-boundary=\"true\">Ad:<\/strong> Pivot tablonuzda g\u00f6r\u00fcnt\u00fclenecek hesaplanan alan\u0131n ad\u0131.<\/li><li> <strong>Form\u00fcl:<\/strong> Hesaplanan alana form\u00fcl eklemek i\u00e7in kullan\u0131lan giri\u015f se\u00e7ene\u011fi.<\/li><li> <strong>Alanlar:<\/strong> Yeni bir alan hesaplamak amac\u0131yla kaynak verilerden di\u011fer alanlar\u0131 se\u00e7mek i\u00e7in a\u00e7\u0131lan bir se\u00e7enek.<\/li><\/ol><h2 id=\"4\" class=\"wp-block-heading\"> Pivot tablodaki hesaplanan \u00f6\u011feler<\/h2><p> Hesaplanan \u00f6\u011feler pivot tablonuzdaki di\u011fer \u00f6\u011feler gibidir ancak aradaki fark, bunlar\u0131n kaynak verilerinizde bulunmamas\u0131d\u0131r. Basit\u00e7e bir form\u00fcl kullan\u0131larak olu\u015fturulurlar. Hesaplanan \u00f6\u011feleri gerekti\u011fi gibi d\u00fczenleyebilir, d\u00fczenleyebilir veya silebilirsiniz.<\/p><ol><li> Pivot tablonuzdaki \u00f6\u011felerden birine t\u0131klaman\u0131z yeterlidir. \u015eeridinizde PivotTable se\u00e7ene\u011finin yan\u0131 s\u0131ra di\u011fer iki se\u00e7ene\u011fi (Analiz ve Tasar\u0131m) g\u00f6receksiniz.<\/li><li> Analiz Et&#8217;i ve ard\u0131ndan Alanlar, \u00d6\u011feler ve K\u00fcmeler&#8217;i t\u0131klay\u0131n.<\/li><li> Ayr\u0131ca se\u00e7eneklerin bir listesini alacaks\u0131n\u0131z, sadece Hesaplanan \u00d6\u011fe&#8217;ye t\u0131klay\u0131n. <br><img decoding=\"async\" title=\"\u00d6zet Tabloya Ekle-Hesaplama-7\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Inserer-le-calcul-dans-le-tableau-croise-dynamique-7-1.png\" sizes=\"\" srcset=\"\" alt=\"Calculated Item Dialog Box To Insert Calculation In Pivot Table\"><\/li><li> Hesaplanan \u00f6\u011feye t\u0131klad\u0131ktan sonra yukar\u0131daki gibi bir i\u00e7erik men\u00fcs\u00fc g\u00f6receksiniz. Bu i\u00e7erik men\u00fcs\u00fc iki giri\u015f se\u00e7ene\u011fini (Ad ve Form\u00fcl) ve iki se\u00e7im se\u00e7ene\u011fini (Alan ve \u00d6\u011feler) i\u00e7erir.<\/li><li> Hesaplanan alanlarda \u201c <strong>Ad, Form\u00fcl ve Alanlar<\/strong> \u201ddan bahsetmi\u015ftik zaten.<\/li><li> <strong>Elemanlar<\/strong> : Hesaplanacak elemanlar\u0131 se\u00e7mek i\u00e7in.<\/li><li> Bu \u00f6rnekte ortalama sat\u0131\u015f fiyat\u0131n\u0131 hesaplayaca\u011f\u0131z ve form\u00fcl = miktar\/miktar olacak.<\/li><li> Alanlar se\u00e7ene\u011finde Tutar&#8217;\u0131 se\u00e7in ve ekle&#8217;ye t\u0131klay\u0131n, ard\u0131ndan b\u00f6lme operat\u00f6r\u00fcn\u00fc &#8220;\/&#8221; ekleyin ve ard\u0131ndan miktar\u0131 girin.<\/li><li> Tamam tu\u015funa bas\u0131n.<\/li><li> Art\u0131k pivot tablonuzda yeni bir alan beliriyor. <br><img decoding=\"async\" title=\"\u00d6zet Tabloya Ekle-Hesaplama-5\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Inserer-le-calcul-dans-le-tableau-croise-dynamique-5-1.png\" sizes=\"\" srcset=\"\" alt=\"Insert Formula In Calculated Feild To Insert Calculation In Pivot Table\"><\/li><li> Yeni hesaplanan alan\u0131n\u0131z herhangi bir say\u0131sal format olmadan olu\u015fturulur. <br><img decoding=\"async\" title=\"\u00d6zet Tablo-6'ya Hesaplama Ekle\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Inserer-le-calcul-dans-le-tableau-croise-dynamique-6-1.png\" sizes=\"\" srcset=\"\" alt=\"Your New Calculated Field By inserting Calculation In Pivot Table\"><\/li><\/ol><p> Bu \u00f6rnekte birinci d\u00f6nem ile ikinci d\u00f6nemin ortalamas\u0131n\u0131 hesaplayaca\u011f\u0131z. Sadece form\u00fcl\u00fc ekleyin.<\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=average(jan, feb, mar, apr, may, jun)<\/code><\/pre><p> Art\u0131k y\u0131l\u0131n ilk alt\u0131 ay\u0131n\u0131n ve son alt\u0131 ay\u0131n\u0131n ortalamas\u0131n\u0131 g\u00f6steren pivot \u00f6\u011felerinizi hesaplaman\u0131z gerekiyor. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Inserer-le-calcul-dans-le-tableau-croise-dynamique-8-1.png\" sizes=\"\" srcset=\"\" alt=\"Pivot tabloya hesaplama eklemek i\u00e7in hesaplanm\u0131\u015f bir \u00f6\u011fe ekleme\"><\/figure><\/div><p> <span style=\"color: #333333;\">Ama bir dakika bekleyin. Bu nedir? Genel toplam 1.506 $ ve 311.820 $\u2019dan 1.746 $ ve 361.600 $\u2019a \u00e7\u0131k\u0131yor.<\/span> <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Inserer-le-calcul-dans-le-tableau-croise-dynamique-9-1.png\" sizes=\"\" srcset=\"\" alt=\"Hesaplaman\u0131n pivot tabloya eklenmesi i\u00e7in hesaplanan \u00f6\u011fe eklendi\"><\/figure><\/div><p> Bunun nedeni pivot tablo toplam ve alt toplamlar\u0131n\u0131n, toplam ve ara toplam hesaplamas\u0131nda hesaplanan alanlar\u0131n\u0131z\u0131 i\u00e7ermesidir. Bu nedenle, ger\u00e7ek g\u00f6r\u00fcnt\u00fcy\u00fc g\u00f6r\u00fcnt\u00fclemek istiyorsan\u0131z hesaplanan \u00f6\u011felerinizi filtrelemeniz gerekir.<\/p><h2 id=\"6\" class=\"wp-block-heading\"> Hat\u0131rlanacak \u015feyler<\/h2><ol><li> Hesaplama i\u00e7in form\u00fcl eklerken form\u00fcl giri\u015fi se\u00e7ene\u011finden 0&#8217;\u0131 kald\u0131rmay\u0131 unutmay\u0131n.<\/li><li> Yaln\u0131zca h\u00fccre ba\u015fvurusu gerektirmeyen form\u00fclleri kullanabilirsiniz.<\/li><li> Hesaplanan \u00f6\u011felerin pivot sonu\u00e7lar\u0131n\u0131z\u0131 (ara toplamlar ve genel toplamlar) etkileyip etkilemedi\u011fini kontrol etmelisiniz.<\/li><li> \u00c7\u00f6z\u00fcm s\u0131ras\u0131n\u0131 hesaplama gereksinimlerinize g\u00f6re ayarlay\u0131n. <\/li><\/ol><div class=\"wp-block-group main-page-bottom is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h2 class=\"wp-block-heading\"> Pivot tablolar hakk\u0131nda daha fazla bilgi edinin<\/h2><ul><li> <a href=\"https:\/\/exceladvisor.org\/tr\/benzersiz-degerleri-say\/\">Excel&#8217;deki bir pivot tablodaki benzersiz de\u011ferleri say\u0131n<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/rutbe-sutunu\/\">Excel&#8217;de pivot tabloya sat\u0131r ekleme<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/grup-tarihleri\/\">Tarihleri bir pivot tabloda gruplama<\/a><\/li><\/ul><\/div><\/div>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-2085","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Excel&#039;de hesaplanan \u00f6\u011feler ve alanlar nas\u0131l kullan\u0131l\u0131r?<\/title>\n<meta name=\"description\" content=\"Pivot tablodaki hesaplamalar, alanlar ve hesaplanan \u00f6\u011feler hesaplanarak yap\u0131labilir.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/tr\/pivot-tabloda-hesaplama\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel&#039;de hesaplanan \u00f6\u011feler ve alanlar nas\u0131l kullan\u0131l\u0131r?\" \/>\n<meta property=\"og:description\" content=\"Pivot tablodaki hesaplamalar, alanlar ve hesaplanan \u00f6\u011feler hesaplanarak yap\u0131labilir.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/tr\/pivot-tabloda-hesaplama\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T06:01:33+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/inserer-le-calcul-dans-le-tableau-croise-dynamique-10.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data1\" content=\"4 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/pivot-tabloda-hesaplama\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/pivot-tabloda-hesaplama\/\",\"name\":\"Excel&#39;de hesaplanan \u00f6\u011feler ve alanlar nas\u0131l kullan\u0131l\u0131r?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/pivot-tabloda-hesaplama\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/pivot-tabloda-hesaplama\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/inserer-le-calcul-dans-le-tableau-croise-dynamique-10.png\",\"datePublished\":\"2023-10-19T04:10:16+00:00\",\"dateModified\":\"2023-12-10T06:01:33+00:00\",\"description\":\"Pivot tablodaki hesaplamalar, alanlar ve hesaplanan \u00f6\u011feler hesaplanarak yap\u0131labilir.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/pivot-tabloda-hesaplama\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/tr\/pivot-tabloda-hesaplama\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/pivot-tabloda-hesaplama\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/inserer-le-calcul-dans-le-tableau-croise-dynamique-10.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/inserer-le-calcul-dans-le-tableau-croise-dynamique-10.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/pivot-tabloda-hesaplama\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/exceladvisor.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel&#39;de hesaplanan \u00f6\u011feler ve alanlar nas\u0131l kullan\u0131l\u0131r?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\",\"url\":\"https:\/\/exceladvisor.org\/tr\/\",\"name\":\"Excel Advisor\",\"description\":\"Veri hakimiyetine y\u00f6nelik nihai rehberiniz!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/tr\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"tr\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/tr\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel&#39;de hesaplanan \u00f6\u011feler ve alanlar nas\u0131l kullan\u0131l\u0131r?","description":"Pivot tablodaki hesaplamalar, alanlar ve hesaplanan \u00f6\u011feler hesaplanarak yap\u0131labilir.","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:\/\/exceladvisor.org\/tr\/pivot-tabloda-hesaplama\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel&#39;de hesaplanan \u00f6\u011feler ve alanlar nas\u0131l kullan\u0131l\u0131r?","og_description":"Pivot tablodaki hesaplamalar, alanlar ve hesaplanan \u00f6\u011feler hesaplanarak yap\u0131labilir.","og_url":"https:\/\/exceladvisor.org\/tr\/pivot-tabloda-hesaplama\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T06:01:33+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/inserer-le-calcul-dans-le-tableau-croise-dynamique-10.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tahmini okuma s\u00fcresi":"4 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/tr\/pivot-tabloda-hesaplama\/","url":"https:\/\/exceladvisor.org\/tr\/pivot-tabloda-hesaplama\/","name":"Excel&#39;de hesaplanan \u00f6\u011feler ve alanlar nas\u0131l kullan\u0131l\u0131r?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/tr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/tr\/pivot-tabloda-hesaplama\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/pivot-tabloda-hesaplama\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/inserer-le-calcul-dans-le-tableau-croise-dynamique-10.png","datePublished":"2023-10-19T04:10:16+00:00","dateModified":"2023-12-10T06:01:33+00:00","description":"Pivot tablodaki hesaplamalar, alanlar ve hesaplanan \u00f6\u011feler hesaplanarak yap\u0131labilir.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/tr\/pivot-tabloda-hesaplama\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/tr\/pivot-tabloda-hesaplama\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/pivot-tabloda-hesaplama\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/inserer-le-calcul-dans-le-tableau-croise-dynamique-10.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/inserer-le-calcul-dans-le-tableau-croise-dynamique-10.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/tr\/pivot-tabloda-hesaplama\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/exceladvisor.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Excel&#39;de hesaplanan \u00f6\u011feler ve alanlar nas\u0131l kullan\u0131l\u0131r?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/tr\/#website","url":"https:\/\/exceladvisor.org\/tr\/","name":"Excel Advisor","description":"Veri hakimiyetine y\u00f6nelik nihai rehberiniz!","publisher":{"@id":"https:\/\/exceladvisor.org\/tr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/tr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"tr"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/tr\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/tr\/","logo":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/2085","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/comments?post=2085"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/2085\/revisions"}],"predecessor-version":[{"id":2538,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/2085\/revisions\/2538"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/media?parent=2085"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}