{"id":2951,"date":"2023-07-19T22:45:01","date_gmt":"2023-07-19T22:45:01","guid":{"rendered":"https:\/\/statorials.org\/id\/filter-atau-kondisi-tabel-pivot-excel\/"},"modified":"2023-07-19T22:45:01","modified_gmt":"2023-07-19T22:45:01","slug":"filter-atau-kondisi-tabel-pivot-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/filter-atau-kondisi-tabel-pivot-excel\/","title":{"rendered":"Excel: cara memfilter pivottable menggunakan kondisi or"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Seringkali, Anda mungkin ingin memfilter nilai dalam tabel pivot di Excel menggunakan kondisi OR.<\/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: Filter tabel pivot menggunakan kondisi OR<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Katakanlah kita memiliki kumpulan data berikut di Excel yang memperlihatkan jumlah poin yang dicetak oleh pemain bola basket yang berbeda:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-25599 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/filtreou1-1.jpg\" alt=\"\" width=\"463\" height=\"456\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Sekarang katakanlah kita ingin membuat tabel pivot untuk merangkum total poin yang dicetak berdasarkan tim dan posisi.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Katakanlah kita mungkin ingin memfilter pemain yang ada di tim <strong>Mavs<\/strong> <strong>atau<\/strong> yang memiliki posisi <strong>penjaga<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita bisa membuat kolom pembantu dengan mengetikkan rumus berikut di sel D2:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=IF(OR( <span style=\"color: #3366ff;\">A2<\/span> =\"Mavs\", <span style=\"color: #ff0000;\">B2<\/span> =\"Guard\"), \"Show\", \"Hide\")\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kita kemudian dapat menyeret rumus ini ke setiap sel yang tersisa di kolom D:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-25600 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/filtreou2.jpg\" alt=\"\" width=\"541\" height=\"423\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Sekarang kita telah membuat kolom pembantu ini, kita dapat membuat tabel pivot.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Sorot sel dalam rentang <strong>A1:D16<\/strong> , lalu klik tab <strong>Sisipkan<\/strong> di sepanjang pita atas, lalu klik <strong>PivotTable<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Di jendela baru yang muncul, kita akan memilih untuk menyisipkan tabel pivot di sel F1 pada lembar kerja saat ini:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-25601 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/filtreou3.jpg\" alt=\"\" width=\"669\" height=\"438\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Di jendela <strong>Bidang PivotTable<\/strong> yang muncul di sisi kanan layar, seret <b>tim<\/b> dan <strong>posisikan<\/strong> ke garis dan <b>titik<\/b> ke nilai:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-25602 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/filtreou4.jpg\" alt=\"\" width=\"299\" height=\"582\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Tabel pivot berikut akan terisi secara otomatis:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-25603 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/filtreou5.jpg\" alt=\"\" width=\"352\" height=\"392\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Untuk memfilter PivotTable agar hanya menampilkan data pemain tim atau penjaga Mavs, klik tab <strong>Analisis PivotTable<\/strong> di sepanjang pita atas, lalu klik <strong>Sisipkan Pemotong<\/strong> di PivotTable. Grup <strong>penyaring<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Di jendela baru yang muncul, centang kotak di sebelah <strong>Filter<\/strong> lalu klik <strong>OK<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-25604 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/filtreou6.jpg\" alt=\"\" width=\"450\" height=\"489\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Pada pemotong baru yang muncul, klik tombol \u201cTampilkan\u201d.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Ini secara otomatis akan memfilter tabel pivot agar hanya menampilkan pemain di tim <strong>Mavs<\/strong> atau yang memiliki posisi <strong>Guard<\/strong> .<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-25605\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/filtreou7.jpg\" alt=\"Filter tabel pivot Excel ATAU kondisi\" width=\"463\" height=\"453\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Dengan membuat kolom pembantu sebelum membuat tabel pivot, kami dapat memfilter tabel pivot menggunakan kondisi OR.<\/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 dalam Tabel Pivot<\/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 kondisi OR. Contoh berikut menunjukkan dengan tepat bagaimana melakukan hal ini. Contoh: Filter tabel pivot menggunakan kondisi OR Katakanlah kita memiliki kumpulan data berikut di Excel yang memperlihatkan jumlah poin yang dicetak oleh pemain bola basket yang berbeda: Sekarang katakanlah kita ingin membuat [&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 Menggunakan Kondisi OR - Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara memfilter tabel pivot menggunakan kondisi OR, beserta sebuah contoh.\" \/>\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-atau-kondisi-tabel-pivot-excel\/\" \/>\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 Menggunakan Kondisi OR - Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara memfilter tabel pivot menggunakan kondisi OR, beserta sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/filter-atau-kondisi-tabel-pivot-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-19T22:45:01+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/filtreou1-1.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=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/filter-atau-kondisi-tabel-pivot-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/filter-atau-kondisi-tabel-pivot-excel\/\",\"name\":\"Excel: Cara Memfilter PivotTable Menggunakan Kondisi OR - Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-19T22:45:01+00:00\",\"dateModified\":\"2023-07-19T22:45:01+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara memfilter tabel pivot menggunakan kondisi OR, beserta sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/filter-atau-kondisi-tabel-pivot-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/filter-atau-kondisi-tabel-pivot-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/filter-atau-kondisi-tabel-pivot-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel: cara memfilter pivottable menggunakan kondisi or\"}]},{\"@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 Menggunakan Kondisi OR - Statorial","description":"Tutorial ini menjelaskan cara memfilter tabel pivot menggunakan kondisi OR, beserta sebuah contoh.","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-atau-kondisi-tabel-pivot-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Excel: Cara Memfilter PivotTable Menggunakan Kondisi OR - Statorial","og_description":"Tutorial ini menjelaskan cara memfilter tabel pivot menggunakan kondisi OR, beserta sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/filter-atau-kondisi-tabel-pivot-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-19T22:45:01+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/filtreou1-1.jpg"}],"author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/filter-atau-kondisi-tabel-pivot-excel\/","url":"https:\/\/statorials.org\/id\/filter-atau-kondisi-tabel-pivot-excel\/","name":"Excel: Cara Memfilter PivotTable Menggunakan Kondisi OR - Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-19T22:45:01+00:00","dateModified":"2023-07-19T22:45:01+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara memfilter tabel pivot menggunakan kondisi OR, beserta sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/filter-atau-kondisi-tabel-pivot-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/filter-atau-kondisi-tabel-pivot-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/filter-atau-kondisi-tabel-pivot-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Excel: cara memfilter pivottable menggunakan kondisi or"}]},{"@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\/2951"}],"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=2951"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2951\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2951"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2951"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2951"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}