{"id":3173,"date":"2023-07-18T20:51:11","date_gmt":"2023-07-18T20:51:11","guid":{"rendered":"https:\/\/statorials.org\/tr\/filtrelenmis-veriler-uzerinde-excel-pivot-tablosu\/"},"modified":"2023-07-18T20:51:11","modified_gmt":"2023-07-18T20:51:11","slug":"filtrelenmis-veriler-uzerinde-excel-pivot-tablosu","status":"publish","type":"post","link":"https:\/\/statorials.org\/tr\/filtrelenmis-veriler-uzerinde-excel-pivot-tablosu\/","title":{"rendered":"Excel: filtrelenmi\u015f verilere dayal\u0131 \u00f6zet tablo nas\u0131l olu\u015fturulur"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Varsay\u0131lan olarak Excel, filtrelenmi\u015f verileri kullanarak bir pivot tablo olu\u015fturamaz.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Bunun yerine Excel, pivot tablo olu\u015fturmak i\u00e7in filtrelenmi\u015f veriler yerine her zaman orijinal verileri kullan\u0131r.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Bu soruna ge\u00e7ici bir \u00e7\u00f6z\u00fcm bulman\u0131n bir yolu, filtrelenen verileri kopyalay\u0131p yeni bir h\u00fccre aral\u0131\u011f\u0131na yap\u0131\u015ft\u0131rmak ve ard\u0131ndan yeni h\u00fccre aral\u0131\u011f\u0131n\u0131 kullanarak bir pivot tablo olu\u015fturmakt\u0131r.<\/span><\/p>\n<p> <span style=\"color: #000000;\">A\u015fa\u011f\u0131daki \u00f6rnek bunun nas\u0131l yap\u0131laca\u011f\u0131n\u0131 tam olarak g\u00f6stermektedir.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>\u00d6rnek: Filtrelenmi\u015f Verilere Dayal\u0131 PivotTable Olu\u015fturma<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Farkl\u0131 tak\u0131mlardaki basketbolcular\u0131n att\u0131\u011f\u0131 say\u0131lar\u0131 g\u00f6steren Excel&#8217;de a\u015fa\u011f\u0131daki verilere sahip oldu\u011fumuzu varsayal\u0131m:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-26952 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pivotfiltre1.jpg\" alt=\"\" width=\"446\" height=\"449\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">\u015eimdi <strong>A1:B12<\/strong> h\u00fccre aral\u0131\u011f\u0131n\u0131 vurgulad\u0131\u011f\u0131m\u0131z\u0131, ard\u0131ndan <strong>Veri<\/strong> sekmesine ve ard\u0131ndan <strong>Filtre<\/strong> simgesine t\u0131klad\u0131\u011f\u0131m\u0131z\u0131 varsayal\u0131m.<\/span><\/p>\n<p> <span style=\"color: #000000;\">\u015eimdi <strong>Team&#8217;in<\/strong> yan\u0131ndaki a\u00e7\u0131l\u0131r oka t\u0131klad\u0131\u011f\u0131m\u0131z\u0131, Mavs ve Warriors&#8217;\u0131n yan\u0131ndaki kutular\u0131 i\u015faretledi\u011fimizi ve ard\u0131ndan <strong>Tamam&#8217;a<\/strong> t\u0131klad\u0131\u011f\u0131m\u0131z\u0131 varsayal\u0131m:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-26954 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pivotfiltre2.jpg\" alt=\"\" width=\"433\" height=\"580\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">Veriler yaln\u0131zca tak\u0131m\u0131n Mavs veya Warriors&#8217;a e\u015fit oldu\u011fu sat\u0131rlar\u0131 g\u00f6sterecek \u015fekilde filtrelenecektir:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-26955 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pivotfiltre3.jpg\" alt=\"\" width=\"455\" height=\"441\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">Bu iki tak\u0131m\u0131n att\u0131\u011f\u0131 puanlar\u0131n toplam\u0131n\u0131 \u00f6zetlemek i\u00e7in bir pivot tablo olu\u015fturulmaya \u00e7al\u0131\u015f\u0131l\u0131rsa, pivot tablo asl\u0131nda t\u00fcm orijinal verileri kullanacakt\u0131r:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-26956 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pivotfiltre4.jpg\" alt=\"\" width=\"481\" height=\"387\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">Bu soruna ge\u00e7ici bir \u00e7\u00f6z\u00fcm bulmak i\u00e7in <strong>A1:B12<\/strong> aral\u0131\u011f\u0131ndaki h\u00fccreleri vurgulay\u0131p kopyalamam\u0131z ve ard\u0131ndan bunlar\u0131 ba\u015fka bir h\u00fccre aral\u0131\u011f\u0131na yap\u0131\u015ft\u0131rmam\u0131z gerekir.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Bu \u00f6rnekte bunlar\u0131 tamamen yeni bir sayfaya yap\u0131\u015ft\u0131raca\u011f\u0131z:<br \/><\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-26957 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pivotfiltre5.jpg\" alt=\"\" width=\"432\" height=\"447\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">\u015eimdi, bu sayfada <strong>A1:B8<\/strong> h\u00fccre aral\u0131\u011f\u0131n\u0131 vurgulay\u0131p bir pivot tablo eklersek, bu tablo yaln\u0131zca filtrelenen verileri i\u00e7erecektir:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-26958 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pivotfiltre6.jpg\" alt=\"\" width=\"496\" height=\"395\" srcset=\"\" sizes=\"auto, \"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Ek kaynaklar<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">A\u015fa\u011f\u0131daki e\u011fitimlerde Excel&#8217;de di\u011fer yayg\u0131n i\u015flemlerin nas\u0131l ger\u00e7ekle\u015ftirilece\u011fi a\u00e7\u0131klanmaktad\u0131r:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/tr\/excel-pivot-tablosu-coklu-filtreler\/\" target=\"_blank\" rel=\"noopener\">Excel: PivotTable&#8217;a Ayn\u0131 Anda Birden \u00c7ok Filtre Nas\u0131l Uygulan\u0131r?<\/a><br \/> <a href=\"https:\/\/statorials.org\/tr\/excel-pivot-tablo-filtresi-veya-kosulu\/\" target=\"_blank\" rel=\"noopener\">Excel: VEYA Ko\u015fulunu Kullanarak PivotTable&#8217;\u0131 Filtreleme<\/a><br \/> <a href=\"https:\/\/statorials.org\/tr\/excel-pivot-tablo-filtresi-tarih-araligi\/\" target=\"_blank\" rel=\"noopener\">Excel: pivot tabloyu tarih aral\u0131\u011f\u0131na g\u00f6re filtreleme<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Varsay\u0131lan olarak Excel, filtrelenmi\u015f verileri kullanarak bir pivot tablo olu\u015fturamaz. Bunun yerine Excel, pivot tablo olu\u015fturmak i\u00e7in filtrelenmi\u015f veriler yerine her zaman orijinal verileri kullan\u0131r. Bu soruna ge\u00e7ici bir \u00e7\u00f6z\u00fcm bulman\u0131n bir yolu, filtrelenen verileri kopyalay\u0131p yeni bir h\u00fccre aral\u0131\u011f\u0131na yap\u0131\u015ft\u0131rmak ve ard\u0131ndan yeni h\u00fccre aral\u0131\u011f\u0131n\u0131 kullanarak bir pivot tablo olu\u015fturmakt\u0131r. A\u015fa\u011f\u0131daki \u00f6rnek bunun nas\u0131l [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[],"class_list":["post-3173","post","type-post","status-publish","format-standard","hentry","category-rehber"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Excel: Filtrelenmi\u015f Verilere Dayal\u0131 \u00d6zet Tablo Nas\u0131l Olu\u015fturulur - Statoryaller<\/title>\n<meta name=\"description\" content=\"Bu e\u011fitimde, Excel&#039;de filtrelenmi\u015f verilere dayal\u0131 bir pivot tablonun nas\u0131l olu\u015fturulaca\u011f\u0131 bir \u00f6rnekle a\u00e7\u0131klanmaktad\u0131r.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/statorials.org\/tr\/filtrelenmis-veriler-uzerinde-excel-pivot-tablosu\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel: Filtrelenmi\u015f Verilere Dayal\u0131 \u00d6zet Tablo Nas\u0131l Olu\u015fturulur - Statoryaller\" \/>\n<meta property=\"og:description\" content=\"Bu e\u011fitimde, Excel&#039;de filtrelenmi\u015f verilere dayal\u0131 bir pivot tablonun nas\u0131l olu\u015fturulaca\u011f\u0131 bir \u00f6rnekle a\u00e7\u0131klanmaktad\u0131r.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/tr\/filtrelenmis-veriler-uzerinde-excel-pivot-tablosu\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-18T20:51:11+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pivotfiltre1.jpg\" \/>\n<meta name=\"author\" content=\"Dr.benjamin anderson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Yazan:\" \/>\n\t<meta name=\"twitter:data1\" content=\"Dr.benjamin anderson\" \/>\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:\/\/statorials.org\/tr\/filtrelenmis-veriler-uzerinde-excel-pivot-tablosu\/\",\"url\":\"https:\/\/statorials.org\/tr\/filtrelenmis-veriler-uzerinde-excel-pivot-tablosu\/\",\"name\":\"Excel: Filtrelenmi\u015f Verilere Dayal\u0131 \u00d6zet Tablo Nas\u0131l Olu\u015fturulur - Statoryaller\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/tr\/#website\"},\"datePublished\":\"2023-07-18T20:51:11+00:00\",\"dateModified\":\"2023-07-18T20:51:11+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48\"},\"description\":\"Bu e\u011fitimde, Excel&#39;de filtrelenmi\u015f verilere dayal\u0131 bir pivot tablonun nas\u0131l olu\u015fturulaca\u011f\u0131 bir \u00f6rnekle a\u00e7\u0131klanmaktad\u0131r.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/tr\/filtrelenmis-veriler-uzerinde-excel-pivot-tablosu\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/tr\/filtrelenmis-veriler-uzerinde-excel-pivot-tablosu\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/tr\/filtrelenmis-veriler-uzerinde-excel-pivot-tablosu\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/statorials.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel: filtrelenmi\u015f verilere dayal\u0131 \u00f6zet tablo nas\u0131l olu\u015fturulur\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/statorials.org\/tr\/#website\",\"url\":\"https:\/\/statorials.org\/tr\/\",\"name\":\"Statorials\",\"description\":\"\u0130statistik okuryazarl\u0131\u011f\u0131 rehberiniz!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/statorials.org\/tr\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"tr\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48\",\"name\":\"Dr.benjamin anderson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/statorials.org\/tr\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/statorials.org\/tr\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"contentUrl\":\"https:\/\/statorials.org\/tr\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"caption\":\"Dr.benjamin anderson\"},\"description\":\"Merhaba, ben Benjamin, emekli bir istatistik profes\u00f6r\u00fc ve Statorials \u00f6\u011fretmenine d\u00f6n\u00fc\u015ft\u00fcm. \u0130statistik alan\u0131ndaki kapsaml\u0131 deneyimim ve uzmanl\u0131\u011f\u0131mla, \u00f6\u011frencilerimi Statorials arac\u0131l\u0131\u011f\u0131yla g\u00fc\u00e7lendirmek i\u00e7in bilgilerimi payla\u015fmaya can at\u0131yorum. Daha fazlas\u0131n\u0131 bil\",\"sameAs\":[\"https:\/\/statorials.org\/tr\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel: Filtrelenmi\u015f Verilere Dayal\u0131 \u00d6zet Tablo Nas\u0131l Olu\u015fturulur - Statoryaller","description":"Bu e\u011fitimde, Excel&#39;de filtrelenmi\u015f verilere dayal\u0131 bir pivot tablonun nas\u0131l olu\u015fturulaca\u011f\u0131 bir \u00f6rnekle a\u00e7\u0131klanmaktad\u0131r.","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:\/\/statorials.org\/tr\/filtrelenmis-veriler-uzerinde-excel-pivot-tablosu\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel: Filtrelenmi\u015f Verilere Dayal\u0131 \u00d6zet Tablo Nas\u0131l Olu\u015fturulur - Statoryaller","og_description":"Bu e\u011fitimde, Excel&#39;de filtrelenmi\u015f verilere dayal\u0131 bir pivot tablonun nas\u0131l olu\u015fturulaca\u011f\u0131 bir \u00f6rnekle a\u00e7\u0131klanmaktad\u0131r.","og_url":"https:\/\/statorials.org\/tr\/filtrelenmis-veriler-uzerinde-excel-pivot-tablosu\/","og_site_name":"Statorials","article_published_time":"2023-07-18T20:51:11+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pivotfiltre1.jpg"}],"author":"Dr.benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Yazan:":"Dr.benjamin anderson","Tahmini okuma s\u00fcresi":"2 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/tr\/filtrelenmis-veriler-uzerinde-excel-pivot-tablosu\/","url":"https:\/\/statorials.org\/tr\/filtrelenmis-veriler-uzerinde-excel-pivot-tablosu\/","name":"Excel: Filtrelenmi\u015f Verilere Dayal\u0131 \u00d6zet Tablo Nas\u0131l Olu\u015fturulur - Statoryaller","isPartOf":{"@id":"https:\/\/statorials.org\/tr\/#website"},"datePublished":"2023-07-18T20:51:11+00:00","dateModified":"2023-07-18T20:51:11+00:00","author":{"@id":"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48"},"description":"Bu e\u011fitimde, Excel&#39;de filtrelenmi\u015f verilere dayal\u0131 bir pivot tablonun nas\u0131l olu\u015fturulaca\u011f\u0131 bir \u00f6rnekle a\u00e7\u0131klanmaktad\u0131r.","breadcrumb":{"@id":"https:\/\/statorials.org\/tr\/filtrelenmis-veriler-uzerinde-excel-pivot-tablosu\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/tr\/filtrelenmis-veriler-uzerinde-excel-pivot-tablosu\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/tr\/filtrelenmis-veriler-uzerinde-excel-pivot-tablosu\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/statorials.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Excel: filtrelenmi\u015f verilere dayal\u0131 \u00f6zet tablo nas\u0131l olu\u015fturulur"}]},{"@type":"WebSite","@id":"https:\/\/statorials.org\/tr\/#website","url":"https:\/\/statorials.org\/tr\/","name":"Statorials","description":"\u0130statistik okuryazarl\u0131\u011f\u0131 rehberiniz!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/statorials.org\/tr\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"tr"},{"@type":"Person","@id":"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48","name":"Dr.benjamin anderson","image":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/statorials.org\/tr\/#\/schema\/person\/image\/","url":"https:\/\/statorials.org\/tr\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","contentUrl":"https:\/\/statorials.org\/tr\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","caption":"Dr.benjamin anderson"},"description":"Merhaba, ben Benjamin, emekli bir istatistik profes\u00f6r\u00fc ve Statorials \u00f6\u011fretmenine d\u00f6n\u00fc\u015ft\u00fcm. \u0130statistik alan\u0131ndaki kapsaml\u0131 deneyimim ve uzmanl\u0131\u011f\u0131mla, \u00f6\u011frencilerimi Statorials arac\u0131l\u0131\u011f\u0131yla g\u00fc\u00e7lendirmek i\u00e7in bilgilerimi payla\u015fmaya can at\u0131yorum. Daha fazlas\u0131n\u0131 bil","sameAs":["https:\/\/statorials.org\/tr"]}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/posts\/3173","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/comments?post=3173"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/posts\/3173\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/media?parent=3173"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/categories?post=3173"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/tags?post=3173"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}