Neyse ki, pivot tablonun Sat\u0131r Etiketleri<\/strong> s\u00fctunu a\u00e7\u0131l\u0131r men\u00fcs\u00fcndeki Tarih Filtreleri<\/strong> se\u00e7ene\u011fini kullanarak bunu yapmak kolayd\u0131r.<\/span><\/p>\n A\u015fa\u011f\u0131daki \u00f6rnek bunun nas\u0131l yap\u0131laca\u011f\u0131n\u0131 tam olarak g\u00f6stermektedir.<\/span><\/p>\n Diyelim ki Excel’de bir \u015firketin farkl\u0131 tarihlerde yapt\u0131\u011f\u0131 sat\u0131\u015flar\u0131n say\u0131s\u0131n\u0131 g\u00f6steren a\u015fa\u011f\u0131daki veri setimiz var:<\/span> <\/p>\n \u015eimdi, ilk s\u00fctunda tarihleri, ikinci s\u00fctunda ise her tarih i\u00e7in sat\u0131\u015flar\u0131n toplam\u0131n\u0131 g\u00f6r\u00fcnt\u00fcleyen a\u015fa\u011f\u0131daki pivot tabloyu olu\u015fturdu\u011fumuzu varsayal\u0131m:<\/span> <\/p>\n Diyelim ki pivot tabloyu yaln\u0131zca Mart ay\u0131nda ger\u00e7ekle\u015fen tarihleri g\u00f6sterecek \u015fekilde filtrelemek istiyoruz.<\/span><\/p>\n Bunu yapmak i\u00e7in, Sat\u0131r Etiketleri<\/strong> adl\u0131 PivotTable ba\u015fl\u0131\u011f\u0131n\u0131n yan\u0131ndaki a\u00e7\u0131l\u0131r oku t\u0131klay\u0131n, ard\u0131ndan Tarih Filtreleri’ni<\/strong> , ard\u0131ndan D\u00f6nemdeki T\u00fcm Tarihler’i<\/strong> ve ard\u0131ndan Mart’\u0131<\/strong> t\u0131klay\u0131n:<\/span> <\/p>\n Pivot tablo yaln\u0131zca Mart ay\u0131nda ger\u00e7ekle\u015fen tarihleri g\u00f6sterecek \u015fekilde otomatik olarak filtreleyecektir:<\/span> <\/p>\n Genel Toplam<\/strong> sat\u0131r\u0131 ayn\u0131 zamanda yaln\u0131zca Mart tarihlerine ait sat\u0131\u015flar\u0131n toplam\u0131n\u0131 da yans\u0131t\u0131r.<\/span><\/p>\n Bu filtreyi kald\u0131rmak i\u00e7in Sat\u0131r Etiketleri’nin<\/strong> yan\u0131ndaki filtre simgesini ve ard\u0131ndan Tarih Filtresini Temizle’yi<\/strong> t\u0131klaman\u0131z yeterlidir.<\/span><\/p>\n A\u015fa\u011f\u0131daki e\u011fitimlerde Excel’de di\u011fer yayg\u0131n i\u015flemlerin nas\u0131l ger\u00e7ekle\u015ftirilece\u011fi a\u00e7\u0131klanmaktad\u0131r:<\/span><\/p>\n Excel: PivotTable’daki \u0130lk 10 De\u011fer Nas\u0131l Filtrelenir<\/a> \u00c7o\u011fu zaman, Excel’deki bir pivot tablonun sat\u0131rlar\u0131n\u0131 aya g\u00f6re filtrelemek isteyebilirsiniz. Neyse ki, pivot tablonun Sat\u0131r Etiketleri s\u00fctunu a\u00e7\u0131l\u0131r men\u00fcs\u00fcndeki Tarih Filtreleri se\u00e7ene\u011fini kullanarak bunu yapmak kolayd\u0131r. A\u015fa\u011f\u0131daki \u00f6rnek bunun nas\u0131l yap\u0131laca\u011f\u0131n\u0131 tam olarak g\u00f6stermektedir. \u00d6rnek: Excel’de PivotTable’\u0131 Aya G\u00f6re Filtreleme Diyelim ki Excel’de bir \u015firketin farkl\u0131 tarihlerde yapt\u0131\u011f\u0131 sat\u0131\u015flar\u0131n say\u0131s\u0131n\u0131 g\u00f6steren a\u015fa\u011f\u0131daki veri setimiz […]<\/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-4932","post","type-post","status-publish","format-standard","hentry","category-rehber"],"yoast_head":"\n \u00d6rnek: Excel’de PivotTable’\u0131 Aya G\u00f6re Filtreleme<\/strong><\/span><\/h2>\n
![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/smois1.png\")
<\/p>\n![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/smois2.png\")
<\/p>\n![\"Excel](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/smois3.png\")
<\/p>\n![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mois4.png\")
<\/p>\n Ek kaynaklar<\/strong><\/span><\/h2>\n
Excel: Pivot tabloyu genel toplama g\u00f6re s\u0131ralama<\/a>
Excel: iki pivot tablo aras\u0131ndaki fark nas\u0131l hesaplan\u0131r<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"