{"id":4930,"date":"2023-07-06T07:04:32","date_gmt":"2023-07-06T07:04:32","guid":{"rendered":"https:\/\/statorials.org\/id\/filter-tabel-pivot-excel-berdasarkan-bulan\/"},"modified":"2023-07-06T07:04:32","modified_gmt":"2023-07-06T07:04:32","slug":"filter-tabel-pivot-excel-berdasarkan-bulan","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/filter-tabel-pivot-excel-berdasarkan-bulan\/","title":{"rendered":"Excel: cara memfilter tabel pivot berdasarkan bulan"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Seringkali, Anda mungkin ingin memfilter baris tabel pivot di Excel berdasarkan bulan.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untungnya, hal ini mudah dilakukan dengan menggunakan opsi <strong>Filter Tanggal<\/strong> di menu drop-down kolom <strong>Label Baris<\/strong> pada tabel pivot.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan dengan tepat bagaimana melakukan hal ini.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh: Filter PivotTable berdasarkan Bulan di Excel<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Katakanlah kita memiliki kumpulan data berikut di Excel yang memperlihatkan jumlah penjualan yang dilakukan oleh suatu perusahaan pada tanggal yang berbeda:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-38482 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/smois1.png\" alt=\"\" width=\"466\" height=\"418\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Sekarang misalkan kita membuat tabel pivot berikut yang menampilkan tanggal di kolom pertama dan jumlah penjualan untuk setiap tanggal di kolom kedua:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-38483 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/smois2.png\" alt=\"\" width=\"537\" height=\"427\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Katakanlah kita ingin memfilter tabel pivot agar hanya menampilkan tanggal yang terjadi di bulan Maret.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk melakukannya, klik panah tarik-turun di samping header PivotTable bernama <strong>Label Baris<\/strong> , lalu klik <strong>Filter Tanggal<\/strong> , lalu klik <strong>Semua Tanggal dalam Periode<\/strong> , lalu klik <strong>Maret<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-38484\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/smois3.png\" alt=\"Filter PivotTable Excel berdasarkan Bulan\" width=\"509\" height=\"594\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Tabel pivot akan secara otomatis memfilter untuk hanya menampilkan tanggal yang terjadi di bulan Maret:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-38485\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mois4.png\" alt=\"\" width=\"532\" height=\"398\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Garis <strong>Total Keseluruhan<\/strong> juga mencerminkan jumlah penjualan untuk tanggal Maret saja.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk menghapus filter ini, cukup klik ikon filter di samping <strong>Label Baris<\/strong> , lalu klik <strong>Hapus Filter Tanggal<\/strong> .<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan operasi umum lainnya di Excel:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><a href=\"https:\/\/statorials.org\/id\/tabel-pivot-excel-10-teratas\/\" target=\"_blank\" rel=\"noopener\">Excel: Cara Memfilter 10 Nilai Teratas di PivotTable<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/excel-mengurutkan-tabel-pivot-berdasarkan-total-umum\/\" target=\"_blank\" rel=\"noopener\">Excel: Cara mengurutkan tabel pivot berdasarkan total keseluruhan<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/excel-menghitung-perbedaan-antara-dua-tabel-pivot\/\" target=\"_blank\" rel=\"noopener\">Excel: cara menghitung selisih antara dua tabel pivot<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Seringkali, Anda mungkin ingin memfilter baris tabel pivot di Excel berdasarkan bulan. Untungnya, hal ini mudah dilakukan dengan menggunakan opsi Filter Tanggal di menu drop-down kolom Label Baris pada tabel pivot. Contoh berikut menunjukkan dengan tepat bagaimana melakukan hal ini. Contoh: Filter PivotTable berdasarkan Bulan di Excel Katakanlah kita memiliki kumpulan data berikut di Excel [&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":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Excel: Cara Memfilter PivotTable berdasarkan Bulan \u2013 Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara memfilter tabel pivot berdasarkan bulan di Excel, dengan contoh lengkap.\" \/>\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\/id\/filter-tabel-pivot-excel-berdasarkan-bulan\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel: Cara Memfilter PivotTable berdasarkan Bulan \u2013 Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara memfilter tabel pivot berdasarkan bulan di Excel, dengan contoh lengkap.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/filter-tabel-pivot-excel-berdasarkan-bulan\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-06T07:04:32+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/smois1.png\" \/>\n<meta name=\"author\" content=\"Benjamin anderson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Ditulis oleh\" \/>\n\t<meta name=\"twitter:data1\" content=\"Benjamin anderson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/filter-tabel-pivot-excel-berdasarkan-bulan\/\",\"url\":\"https:\/\/statorials.org\/id\/filter-tabel-pivot-excel-berdasarkan-bulan\/\",\"name\":\"Excel: Cara Memfilter PivotTable berdasarkan Bulan \u2013 Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-06T07:04:32+00:00\",\"dateModified\":\"2023-07-06T07:04:32+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara memfilter tabel pivot berdasarkan bulan di Excel, dengan contoh lengkap.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/filter-tabel-pivot-excel-berdasarkan-bulan\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/filter-tabel-pivot-excel-berdasarkan-bulan\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/filter-tabel-pivot-excel-berdasarkan-bulan\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel: cara memfilter tabel pivot berdasarkan bulan\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/statorials.org\/id\/#website\",\"url\":\"https:\/\/statorials.org\/id\/\",\"name\":\"Statorials\",\"description\":\"Panduan anda untuk kompetensi statistik!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/statorials.org\/id\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"id\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\",\"name\":\"Benjamin anderson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/\",\"url\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"contentUrl\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"caption\":\"Benjamin anderson\"},\"description\":\"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya\",\"sameAs\":[\"http:\/\/statorials.org\/id\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel: Cara Memfilter PivotTable berdasarkan Bulan \u2013 Statologi","description":"Tutorial ini menjelaskan cara memfilter tabel pivot berdasarkan bulan di Excel, dengan contoh lengkap.","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\/id\/filter-tabel-pivot-excel-berdasarkan-bulan\/","og_locale":"id_ID","og_type":"article","og_title":"Excel: Cara Memfilter PivotTable berdasarkan Bulan \u2013 Statologi","og_description":"Tutorial ini menjelaskan cara memfilter tabel pivot berdasarkan bulan di Excel, dengan contoh lengkap.","og_url":"https:\/\/statorials.org\/id\/filter-tabel-pivot-excel-berdasarkan-bulan\/","og_site_name":"Statorials","article_published_time":"2023-07-06T07:04:32+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/smois1.png"}],"author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"1 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/filter-tabel-pivot-excel-berdasarkan-bulan\/","url":"https:\/\/statorials.org\/id\/filter-tabel-pivot-excel-berdasarkan-bulan\/","name":"Excel: Cara Memfilter PivotTable berdasarkan Bulan \u2013 Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-06T07:04:32+00:00","dateModified":"2023-07-06T07:04:32+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara memfilter tabel pivot berdasarkan bulan di Excel, dengan contoh lengkap.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/filter-tabel-pivot-excel-berdasarkan-bulan\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/filter-tabel-pivot-excel-berdasarkan-bulan\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/filter-tabel-pivot-excel-berdasarkan-bulan\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Excel: cara memfilter tabel pivot berdasarkan bulan"}]},{"@type":"WebSite","@id":"https:\/\/statorials.org\/id\/#website","url":"https:\/\/statorials.org\/id\/","name":"Statorials","description":"Panduan anda untuk kompetensi statistik!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/statorials.org\/id\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"id"},{"@type":"Person","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81","name":"Benjamin anderson","image":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/","url":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","contentUrl":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","caption":"Benjamin anderson"},"description":"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya","sameAs":["http:\/\/statorials.org\/id"]}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4930"}],"collection":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/comments?post=4930"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4930\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4930"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4930"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4930"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}