{"id":2818,"date":"2023-07-20T13:47:24","date_gmt":"2023-07-20T13:47:24","guid":{"rendered":"https:\/\/statorials.org\/id\/tabel-pivot-excel-10-teratas\/"},"modified":"2023-07-20T13:47:24","modified_gmt":"2023-07-20T13:47:24","slug":"tabel-pivot-excel-10-teratas","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/tabel-pivot-excel-10-teratas\/","title":{"rendered":"Excel: cara memfilter 10 nilai teratas di pivottable"},"content":{"rendered":"

<\/p>\n

\n

Contoh langkah demi langkah berikut ini memperlihatkan cara memfilter 10 nilai teratas dalam tabel pivot Excel.<\/span><\/p>\n

Langkah 1: Masukkan datanya<\/strong><\/span><\/h3>\n

Mari kita mulai dengan memasukkan data penjualan berikut untuk 15 toko berbeda:<\/span> <\/p>\n

\"\"<\/p>\n

Langkah 2: Buat tabel pivot<\/strong><\/span><\/h3>\n

Untuk membuat tabel pivot, klik tab Sisipkan<\/strong> di sepanjang pita atas, lalu klik ikon tabel pivot<\/strong> :<\/span> <\/p>\n

\"\"<\/p>\n

Di jendela baru yang muncul, pilih A1:C26<\/strong> sebagai rentang dan pilih untuk menempatkan tabel pivot di sel E1<\/strong> lembar kerja yang ada:<\/span> <\/p>\n

\"\"<\/p>\n

Setelah Anda mengklik OK<\/strong> , panel Bidang PivotTable<\/strong> baru akan muncul di sisi kanan layar.<\/span><\/p>\n

Seret bidang Penyimpanan<\/strong> ke area Baris<\/strong> , lalu seret bidang Penjualan<\/b> dan Pengembalian<\/strong> ke area Nilai<\/strong> :<\/span> <\/p>\n

\"\"<\/p>\n

Tabel pivot secara otomatis akan diisi dengan nilai-nilai berikut:<\/span> <\/p>\n

\"\"<\/p>\n

Langkah 3: Filter 10 nilai teratas di tabel pivot<\/strong><\/span><\/h3>\n

Untuk melihat 10 toko dengan nilai tertinggi saja pada kolom Total Penjualan<\/strong> , klik kanan salah satu nama toko.<\/span><\/p>\n

Di menu tarik-turun yang muncul, klik Filter<\/strong> , lalu klik 10 Teratas<\/strong> :<\/span> <\/p>\n

\"Filter<\/p>\n

Pada jendela baru yang muncul, pilih Top 10 Items by Sum of Sales<\/strong> , lalu klik OK<\/strong> :<\/span> <\/p>\n

\"\"<\/p>\n

Tabel pivot akan secara otomatis memfilter untuk menampilkan hanya 10 toko dengan 10 nilai teratas untuk kolom Jumlah Penjualan<\/strong> :<\/span> <\/p>\n

\"\"<\/p>\n

Catatan<\/strong> : Anda dapat menggunakan angka selain 10 untuk memfilter sejumlah nilai utama yang berbeda.<\/span><\/p>\n

Langkah 4: Urutkan 10 Nilai Teratas di PivotTable (Opsional)<\/strong><\/span><\/h3>\n

Perhatikan bahwa opsi filter menampilkan 10 toko dengan nilai penjualan tertinggi, namun tidak secara otomatis menampilkannya dalam urutan yang diurutkan.<\/span><\/p>\n

Untuk mengurutkan toko berdasarkan nilai penjualan, klik kanan nilai apa pun di kolom Jumlah Penjualan<\/strong> , lalu klik Urutkan<\/strong> , lalu klik Urutkan dari yang Terbesar ke Terkecil<\/strong> :<\/span> <\/p>\n

\"\"<\/p>\n

Toko-toko di tabel pivot akan otomatis diurutkan dari yang terbesar ke yang terkecil berdasarkan penjualan:<\/span> <\/p>\n

\"\"<\/p>\n

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

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

Cara mengurutkan tabel pivot berdasarkan total keseluruhan di Excel<\/a>
Cara mengelompokkan nilai dalam tabel pivot berdasarkan rentang di Excel<\/a>
Cara mengelompokkan berdasarkan bulan dan tahun dalam tabel pivot di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

Contoh langkah demi langkah berikut ini memperlihatkan cara memfilter 10 nilai teratas dalam tabel pivot Excel. Langkah 1: Masukkan datanya Mari kita mulai dengan memasukkan data penjualan berikut untuk 15 toko berbeda: Langkah 2: Buat tabel pivot Untuk membuat tabel pivot, klik tab Sisipkan di sepanjang pita atas, lalu klik ikon tabel pivot : Di […]<\/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 Memfilter 10 Nilai Teratas di PivotTable - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara memfilter 10 nilai pertama tabel pivot di Excel, termasuk contoh langkah demi langkah.\" \/>\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-10-teratas\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel: Cara Memfilter 10 Nilai Teratas di PivotTable - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara memfilter 10 nilai pertama tabel pivot di Excel, termasuk contoh langkah demi langkah.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/tabel-pivot-excel-10-teratas\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-20T13:47:24+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/filtrepivot1.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-10-teratas\/\",\"url\":\"https:\/\/statorials.org\/id\/tabel-pivot-excel-10-teratas\/\",\"name\":\"Excel: Cara Memfilter 10 Nilai Teratas di PivotTable - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-20T13:47:24+00:00\",\"dateModified\":\"2023-07-20T13:47:24+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara memfilter 10 nilai pertama tabel pivot di Excel, termasuk contoh langkah demi langkah.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/tabel-pivot-excel-10-teratas\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/tabel-pivot-excel-10-teratas\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/tabel-pivot-excel-10-teratas\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel: cara memfilter 10 nilai teratas di pivottable\"}]},{\"@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 10 Nilai Teratas di PivotTable - Statorials","description":"Tutorial ini menjelaskan cara memfilter 10 nilai pertama tabel pivot di Excel, termasuk contoh langkah demi langkah.","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-10-teratas\/","og_locale":"id_ID","og_type":"article","og_title":"Excel: Cara Memfilter 10 Nilai Teratas di PivotTable - Statorials","og_description":"Tutorial ini menjelaskan cara memfilter 10 nilai pertama tabel pivot di Excel, termasuk contoh langkah demi langkah.","og_url":"https:\/\/statorials.org\/id\/tabel-pivot-excel-10-teratas\/","og_site_name":"Statorials","article_published_time":"2023-07-20T13:47:24+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/filtrepivot1.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-10-teratas\/","url":"https:\/\/statorials.org\/id\/tabel-pivot-excel-10-teratas\/","name":"Excel: Cara Memfilter 10 Nilai Teratas di PivotTable - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-20T13:47:24+00:00","dateModified":"2023-07-20T13:47:24+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara memfilter 10 nilai pertama tabel pivot di Excel, termasuk contoh langkah demi langkah.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/tabel-pivot-excel-10-teratas\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/tabel-pivot-excel-10-teratas\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/tabel-pivot-excel-10-teratas\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Excel: cara memfilter 10 nilai teratas di pivottable"}]},{"@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\/2818"}],"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=2818"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2818\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2818"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2818"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2818"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}