{"id":3114,"date":"2023-07-19T03:51:54","date_gmt":"2023-07-19T03:51:54","guid":{"rendered":"https:\/\/statorials.org\/id\/filter-atas-tabel-pivot-excel-a\/"},"modified":"2023-07-19T03:51:54","modified_gmt":"2023-07-19T03:51:54","slug":"filter-atas-tabel-pivot-excel-a","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/filter-atas-tabel-pivot-excel-a\/","title":{"rendered":"Excel: cara memfilter data di pivottable menggunakan \u201clebih besar dari\u201d"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Seringkali, Anda mungkin ingin memfilter nilai dalam tabel pivot di Excel menggunakan filter &#8220;Lebih Besar dari&#8221;.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untungnya, hal ini mudah dilakukan dengan menggunakan menu drop-down <strong>Filter Nilai<\/strong> di 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<h3> <span style=\"color: #000000;\"><strong>Contoh: Memfilter data dalam tabel pivot menggunakan \u201cLebih Besar dari\u201d<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Katakanlah kita memiliki kumpulan data berikut di Excel yang memperlihatkan jumlah penjualan empat produk berbeda:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-26565 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pivotplus-grand1.jpg\" alt=\"\" width=\"478\" height=\"456\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Sekarang anggaplah kita membuat tabel pivot berikut untuk merangkum total penjualan setiap produk:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-26566 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pivotplus-grand2.jpg\" alt=\"\" width=\"503\" height=\"503\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Sekarang katakanlah kita ingin memfilter tabel pivot agar hanya menampilkan baris yang <strong>jumlah penjualannya<\/strong> lebih besar dari 10.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk melakukannya, klik panah tarik-turun di samping <strong>Label Baris<\/strong> , lalu klik <strong>Filter Nilai<\/strong> , lalu klik <strong>Lebih Besar Dari<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-26567\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pivotplus-grand3.jpg\" alt=\"Filter PivotTable Excel Di Atas\" width=\"529\" height=\"447\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Pada jendela yang muncul, ketik <strong>10<\/strong> pada ruang kosong lalu klik <strong>OK<\/strong> :<\/span><\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-26568 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pivotplus-grand4.jpg\" alt=\"\" width=\"518\" height=\"466\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Tabel pivot akan secara otomatis memfilter untuk hanya menampilkan baris yang <strong>jumlah penjualannya<\/strong> lebih besar dari 10:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-26569 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pivotplus-grand5.jpg\" alt=\"\" width=\"489\" height=\"387\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Untuk menghapus filter, cukup klik lagi panah tarik-turun di sebelah <strong>Label Baris<\/strong> , lalu klik <strong>Hapus Filter dari \u201cProduk\u201d.<\/strong><\/span><\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan operasi umum lainnya di Excel:<\/span><\/p>\n<p> <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><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Seringkali, Anda mungkin ingin memfilter nilai dalam tabel pivot di Excel menggunakan filter &#8220;Lebih Besar dari&#8221;. Untungnya, hal ini mudah dilakukan dengan menggunakan menu drop-down Filter Nilai di kolom Label Baris pada tabel pivot. Contoh berikut menunjukkan dengan tepat bagaimana melakukan hal ini. Contoh: Memfilter data dalam tabel pivot menggunakan \u201cLebih Besar dari\u201d Katakanlah kita [&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 Data di PivotTable Menggunakan \u201cLebih Besar Dari\u201d - Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara memfilter data dalam tabel pivot di Excel menggunakan filter &quot;lebih besar dari&quot;.\" \/>\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-atas-tabel-pivot-excel-a\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel: Cara Memfilter Data di PivotTable Menggunakan \u201cLebih Besar Dari\u201d - Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara memfilter data dalam tabel pivot di Excel menggunakan filter &quot;lebih besar dari&quot;.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/filter-atas-tabel-pivot-excel-a\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-19T03:51:54+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pivotplus-grand1.jpg\" \/>\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-atas-tabel-pivot-excel-a\/\",\"url\":\"https:\/\/statorials.org\/id\/filter-atas-tabel-pivot-excel-a\/\",\"name\":\"Excel: Cara Memfilter Data di PivotTable Menggunakan \u201cLebih Besar Dari\u201d - Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-19T03:51:54+00:00\",\"dateModified\":\"2023-07-19T03:51:54+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara memfilter data dalam tabel pivot di Excel menggunakan filter &quot;lebih besar dari&quot;.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/filter-atas-tabel-pivot-excel-a\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/filter-atas-tabel-pivot-excel-a\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/filter-atas-tabel-pivot-excel-a\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel: cara memfilter data di pivottable menggunakan \u201clebih besar dari\u201d\"}]},{\"@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 Data di PivotTable Menggunakan \u201cLebih Besar Dari\u201d - Statorial","description":"Tutorial ini menjelaskan cara memfilter data dalam tabel pivot di Excel menggunakan filter &quot;lebih besar dari&quot;.","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-atas-tabel-pivot-excel-a\/","og_locale":"id_ID","og_type":"article","og_title":"Excel: Cara Memfilter Data di PivotTable Menggunakan \u201cLebih Besar Dari\u201d - Statorial","og_description":"Tutorial ini menjelaskan cara memfilter data dalam tabel pivot di Excel menggunakan filter &quot;lebih besar dari&quot;.","og_url":"https:\/\/statorials.org\/id\/filter-atas-tabel-pivot-excel-a\/","og_site_name":"Statorials","article_published_time":"2023-07-19T03:51:54+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pivotplus-grand1.jpg"}],"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-atas-tabel-pivot-excel-a\/","url":"https:\/\/statorials.org\/id\/filter-atas-tabel-pivot-excel-a\/","name":"Excel: Cara Memfilter Data di PivotTable Menggunakan \u201cLebih Besar Dari\u201d - Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-19T03:51:54+00:00","dateModified":"2023-07-19T03:51:54+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara memfilter data dalam tabel pivot di Excel menggunakan filter &quot;lebih besar dari&quot;.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/filter-atas-tabel-pivot-excel-a\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/filter-atas-tabel-pivot-excel-a\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/filter-atas-tabel-pivot-excel-a\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Excel: cara memfilter data di pivottable menggunakan \u201clebih besar dari\u201d"}]},{"@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\/3114"}],"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=3114"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3114\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3114"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3114"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3114"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}