{"id":3170,"date":"2023-07-18T21:13:15","date_gmt":"2023-07-18T21:13:15","guid":{"rendered":"https:\/\/statorials.org\/id\/tabel-pivot-excel-diurutkan-berdasarkan-tanggal\/"},"modified":"2023-07-18T21:13:15","modified_gmt":"2023-07-18T21:13:15","slug":"tabel-pivot-excel-diurutkan-berdasarkan-tanggal","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/tabel-pivot-excel-diurutkan-berdasarkan-tanggal\/","title":{"rendered":"Excel: cara mengurutkan tabel pivot berdasarkan tanggal"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Seringkali, Anda mungkin ingin mengurutkan baris tabel pivot di Excel berdasarkan tanggal.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untungnya, hal ini mudah dilakukan dengan menggunakan opsi pengurutan di menu drop-down 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<h2> <span style=\"color: #000000;\"><strong>Contoh: Urutkan PivotTable berdasarkan Tanggal di Excel<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Katakanlah kita memiliki kumpulan data berikut di Excel yang memperlihatkan jumlah penjualan pada tanggal berbeda:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-26924 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/date-de-tri-pivot1.jpg\" alt=\"\" width=\"465\" height=\"460\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Sebelum Anda membuat PivotTable untuk data ini, klik salah satu sel di kolom Tanggal dan pastikan Excel mengenali sel tersebut sebagai format <strong>tanggal<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-26925 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/date-de-tri-pivot2.jpg\" alt=\"\" width=\"538\" height=\"510\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya, kita dapat menyorot rentang sel <strong>A1:B10<\/strong> , lalu klik tab <strong>Sisipkan<\/strong> di sepanjang pita atas, lalu klik <strong>PivotTable<\/strong> dan masukkan tabel pivot berikut untuk merangkum total penjualan setiap tanggal:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-26926 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/date-de-tri-pivot3.jpg\" alt=\"\" width=\"485\" height=\"428\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Karena Excel mengenali format tanggal, maka secara otomatis mengurutkan PivotTable berdasarkan tanggal, dari terlama hingga terbaru.<\/span><\/span><\/p>\n<p> <span style=\"color: #000000;\">Namun, jika kita ingin mengurutkan dari yang terbaru ke yang terlama, kita dapat mengklik panah drop-down di samping <strong>label baris<\/strong> dan klik <strong>Sortir Terbaru ke Terlama<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-26927\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/date-de-tri-pivot4.jpg\" alt=\"Tabel pivot keluaran Excel berdasarkan tanggal\" width=\"449\" height=\"571\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Baris tabel pivot akan otomatis diurutkan dari terbaru ke terlama:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-26928\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/date-de-tri-pivot5.jpg\" alt=\"PivotTable Excel mengurutkan tanggal terlama ke tanggal terbaru\" width=\"499\" height=\"421\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Untuk mengurutkan dari tanggal terlama ke terbaru, cukup klik lagi panah tarik-turun di samping <strong>Label Baris<\/strong> , lalu klik <strong>Urutkan Terlama ke Terbaru<\/strong> .<\/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 mengurutkan baris tabel pivot di Excel berdasarkan tanggal. Untungnya, hal ini mudah dilakukan dengan menggunakan opsi pengurutan di menu drop-down di kolom Label Baris pada tabel pivot. Contoh berikut menunjukkan dengan tepat bagaimana melakukan hal ini. Contoh: Urutkan PivotTable berdasarkan Tanggal 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 mengurutkan tabel pivot berdasarkan tanggal - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mengurutkan tabel pivot berdasarkan tanggal di Excel, dengan 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\/tabel-pivot-excel-diurutkan-berdasarkan-tanggal\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel: Cara mengurutkan tabel pivot berdasarkan tanggal - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mengurutkan tabel pivot berdasarkan tanggal di Excel, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/tabel-pivot-excel-diurutkan-berdasarkan-tanggal\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-18T21:13:15+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/date-de-tri-pivot1.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-diurutkan-berdasarkan-tanggal\/\",\"url\":\"https:\/\/statorials.org\/id\/tabel-pivot-excel-diurutkan-berdasarkan-tanggal\/\",\"name\":\"Excel: Cara mengurutkan tabel pivot berdasarkan tanggal - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-18T21:13:15+00:00\",\"dateModified\":\"2023-07-18T21:13:15+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mengurutkan tabel pivot berdasarkan tanggal di Excel, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/tabel-pivot-excel-diurutkan-berdasarkan-tanggal\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/tabel-pivot-excel-diurutkan-berdasarkan-tanggal\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/tabel-pivot-excel-diurutkan-berdasarkan-tanggal\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel: cara mengurutkan tabel pivot berdasarkan tanggal\"}]},{\"@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 mengurutkan tabel pivot berdasarkan tanggal - Statorials","description":"Tutorial ini menjelaskan cara mengurutkan tabel pivot berdasarkan tanggal di Excel, dengan 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\/tabel-pivot-excel-diurutkan-berdasarkan-tanggal\/","og_locale":"id_ID","og_type":"article","og_title":"Excel: Cara mengurutkan tabel pivot berdasarkan tanggal - Statorials","og_description":"Tutorial ini menjelaskan cara mengurutkan tabel pivot berdasarkan tanggal di Excel, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/tabel-pivot-excel-diurutkan-berdasarkan-tanggal\/","og_site_name":"Statorials","article_published_time":"2023-07-18T21:13:15+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/date-de-tri-pivot1.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-diurutkan-berdasarkan-tanggal\/","url":"https:\/\/statorials.org\/id\/tabel-pivot-excel-diurutkan-berdasarkan-tanggal\/","name":"Excel: Cara mengurutkan tabel pivot berdasarkan tanggal - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-18T21:13:15+00:00","dateModified":"2023-07-18T21:13:15+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mengurutkan tabel pivot berdasarkan tanggal di Excel, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/tabel-pivot-excel-diurutkan-berdasarkan-tanggal\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/tabel-pivot-excel-diurutkan-berdasarkan-tanggal\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/tabel-pivot-excel-diurutkan-berdasarkan-tanggal\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Excel: cara mengurutkan tabel pivot berdasarkan tanggal"}]},{"@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\/3170"}],"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=3170"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3170\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3170"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3170"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3170"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}