{"id":3173,"date":"2023-07-18T20:51:11","date_gmt":"2023-07-18T20:51:11","guid":{"rendered":"https:\/\/statorials.org\/id\/tabel-pivot-excel-pada-data-yang-difilter\/"},"modified":"2023-07-18T20:51:11","modified_gmt":"2023-07-18T20:51:11","slug":"tabel-pivot-excel-pada-data-yang-difilter","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/tabel-pivot-excel-pada-data-yang-difilter\/","title":{"rendered":"Excel: cara membuat pivottable berdasarkan data yang difilter"},"content":{"rendered":"

<\/p>\n

\n

Secara default, Excel gagal membuat tabel pivot menggunakan data yang difilter.<\/span><\/p>\n

Sebaliknya, Excel selalu menggunakan data asli untuk membuat tabel pivot, bukan data yang difilter.<\/span><\/p>\n

Salah satu cara untuk mengatasi masalah ini adalah dengan menyalin dan menempelkan data yang difilter ke dalam rentang sel baru, lalu membuat tabel pivot menggunakan rentang sel baru tersebut.<\/span><\/p>\n

Contoh berikut menunjukkan dengan tepat bagaimana melakukan hal ini.<\/span><\/p>\n

Contoh: Membuat PivotTable Berdasarkan Data yang Difilter<\/strong><\/span><\/h2>\n

Misalkan kita memiliki data berikut di Excel yang memperlihatkan poin yang dicetak oleh pemain bola basket dari tim berbeda:<\/span> <\/p>\n

\"\"<\/p>\n

Sekarang misalkan kita menyorot cell range A1:B12<\/strong> , lalu klik tab Data<\/strong> , lalu klik ikon Filter<\/strong> .<\/span><\/p>\n

Sekarang misalkan kita klik panah drop-down di sebelah Team<\/strong> , centang kotak di sebelah Mavs dan Warriors, lalu klik OK<\/strong> :<\/span> <\/p>\n

\"\"<\/p>\n

Data akan difilter untuk hanya menampilkan baris dengan tim yang setara dengan Mavs atau Warriors:<\/span> <\/p>\n

\"\"<\/p>\n

Jika seseorang mencoba membuat tabel pivot untuk merangkum jumlah poin yang dicetak oleh kedua tim, tabel pivot sebenarnya akan menggunakan semua data asli:<\/span> <\/p>\n

\"\"<\/p>\n

Untuk mengatasi masalah ini, kita perlu menyorot dan menyalin sel dalam rentang A1:B12<\/strong> lalu menempelkannya ke rentang sel lain.<\/span><\/p>\n

Untuk contoh ini, kami akan menempelkan semuanya ke dalam sheet baru:
<\/span> <\/p>\n

\"\"<\/p>\n

Sekarang, jika kita menyorot rentang sel A1:B8<\/strong> di lembar ini dan menyisipkan tabel pivot, tabel tersebut hanya akan berisi data yang difilter:<\/span> <\/p>\n

\"\"<\/p>\n

Sumber daya tambahan<\/strong><\/span><\/h3>\n

Tutorial berikut menjelaskan cara melakukan operasi umum lainnya di Excel:<\/span><\/p>\n

Excel: Cara Menerapkan Beberapa Filter ke PivotTable Sekaligus<\/a>
Excel: Cara Memfilter PivotTable Menggunakan Kondisi OR<\/a>
Excel: cara memfilter tabel pivot berdasarkan rentang tanggal<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

Secara default, Excel gagal membuat tabel pivot menggunakan data yang difilter. Sebaliknya, Excel selalu menggunakan data asli untuk membuat tabel pivot, bukan data yang difilter. Salah satu cara untuk mengatasi masalah ini adalah dengan menyalin dan menempelkan data yang difilter ke dalam rentang sel baru, lalu membuat tabel pivot menggunakan rentang sel baru tersebut. Contoh […]<\/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":"\nExcel: Cara Membuat PivotTable Berdasarkan Data yang Difilter - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara membuat tabel pivot berdasarkan data yang difilter di Excel, beserta contohnya.\" \/>\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\/tabel-pivot-excel-pada-data-yang-difilter\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel: Cara Membuat PivotTable Berdasarkan Data yang Difilter - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara membuat tabel pivot berdasarkan data yang difilter di Excel, beserta contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/tabel-pivot-excel-pada-data-yang-difilter\/\" \/>\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=\"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\/tabel-pivot-excel-pada-data-yang-difilter\/\",\"url\":\"https:\/\/statorials.org\/id\/tabel-pivot-excel-pada-data-yang-difilter\/\",\"name\":\"Excel: Cara Membuat PivotTable Berdasarkan Data yang Difilter - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-18T20:51:11+00:00\",\"dateModified\":\"2023-07-18T20:51:11+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara membuat tabel pivot berdasarkan data yang difilter di Excel, beserta contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/tabel-pivot-excel-pada-data-yang-difilter\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/tabel-pivot-excel-pada-data-yang-difilter\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/tabel-pivot-excel-pada-data-yang-difilter\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel: cara membuat pivottable berdasarkan data yang difilter\"}]},{\"@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 Membuat PivotTable Berdasarkan Data yang Difilter - Statorials","description":"Tutorial ini menjelaskan cara membuat tabel pivot berdasarkan data yang difilter di Excel, beserta contohnya.","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\/tabel-pivot-excel-pada-data-yang-difilter\/","og_locale":"id_ID","og_type":"article","og_title":"Excel: Cara Membuat PivotTable Berdasarkan Data yang Difilter - Statorials","og_description":"Tutorial ini menjelaskan cara membuat tabel pivot berdasarkan data yang difilter di Excel, beserta contohnya.","og_url":"https:\/\/statorials.org\/id\/tabel-pivot-excel-pada-data-yang-difilter\/","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":"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\/tabel-pivot-excel-pada-data-yang-difilter\/","url":"https:\/\/statorials.org\/id\/tabel-pivot-excel-pada-data-yang-difilter\/","name":"Excel: Cara Membuat PivotTable Berdasarkan Data yang Difilter - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-18T20:51:11+00:00","dateModified":"2023-07-18T20:51:11+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara membuat tabel pivot berdasarkan data yang difilter di Excel, beserta contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/tabel-pivot-excel-pada-data-yang-difilter\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/tabel-pivot-excel-pada-data-yang-difilter\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/tabel-pivot-excel-pada-data-yang-difilter\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Excel: cara membuat pivottable berdasarkan data yang difilter"}]},{"@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\/3173"}],"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=3173"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3173\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3173"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3173"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3173"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}