{"id":3519,"date":"2023-07-17T01:43:53","date_gmt":"2023-07-17T01:43:53","guid":{"rendered":"https:\/\/statorials.org\/id\/perbedaan-persentase-tabel-pivot-excel-antara-dua-kolom\/"},"modified":"2023-07-17T01:43:53","modified_gmt":"2023-07-17T01:43:53","slug":"perbedaan-persentase-tabel-pivot-excel-antara-dua-kolom","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/perbedaan-persentase-tabel-pivot-excel-antara-dua-kolom\/","title":{"rendered":"Excel: temukan perbedaan persentase antara dua kolom dalam tabel pivot"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Contoh langkah demi langkah berikut ini memperlihatkan cara menghitung perbedaan persentase antara dua kolom dalam tabel pivot di Excel.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 1: Masukkan datanya<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Mari kita mulai dengan memasukkan data penjualan berikut untuk tiga toko berbeda:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-29257 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/diff1-1.jpg\" alt=\"\" width=\"478\" height=\"451\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 2: Buat PivotTable<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Selanjutnya, mari buat tabel pivot berikut untuk merangkum total penjualan menurut toko dan tahun:<\/span><\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-29258 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/diff2.jpg\" alt=\"\" width=\"446\" height=\"422\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 3: Hitung selisih persentase antara dua kolom tabel pivot<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Katakanlah kita ingin membuat kolom baru di PivotTable yang menampilkan perbedaan persentase antara kolom <strong>Jumlah 2021<\/strong> dan <strong>Jumlah 2022<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk melakukan ini, kita perlu menambahkan bidang terhitung ke PivotTable dengan mengklik nilai apa pun di PivotTable, lalu mengklik tab <strong>Analisis PivotTable<\/strong> , lalu mengklik <strong>Bidang, Item &amp; Kumpulan<\/strong> , lalu pada <strong>Bidang terhitung<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24481 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/soustraire5.jpg\" alt=\"\" width=\"535\" height=\"310\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Pada jendela baru yang muncul, ketikkan &#8220;Persentase Perbedaan&#8221; pada kolom Nama, lalu masukkan yang berikut ini pada kolom Rumus:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>= ('2022' - '2021') \/ '2021'\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Lalu klik <strong>Tambah<\/strong> , lalu klik <strong>OK<\/strong> .<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-29259 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/diff3-1.jpg\" alt=\"\" width=\"585\" height=\"433\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Bidang terhitung ini akan secara otomatis ditambahkan ke tabel pivot:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-29260 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/diff4.jpg\" alt=\"\" width=\"541\" height=\"267\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Bidang baru ini menampilkan perbedaan persentase antara penjualan tahun 2022 dan 2021 untuk setiap toko.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Ada peningkatan penjualan <strong>sebesar 16,67%<\/strong> antara tahun 2021 dan 2022 untuk Toko A.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Ada peningkatan penjualan <strong>sebesar 15,44%<\/strong> antara tahun 2021 dan 2022 untuk Toko B.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Penjualan Toko C meningkat sebesar <strong>24,62%<\/strong> antara tahun 2021 dan 2022.<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Jangan ragu untuk menyorot nilai di bidang baru dan mengubah formatnya menjadi persentase:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-29261\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/diff5.jpg\" alt=\"Perbedaan persentase antar kolom di PivotTable Excel\" width=\"500\" height=\"374\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di Excel:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/tabel-pivot-excel-menjumlahkan-dua-kolom\/\" target=\"_blank\" rel=\"noopener\">Bagaimana cara menambahkan dua kolom ke tabel pivot di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/tabel-pivot-excel-kurangi-dua-kolom\/\" target=\"_blank\" rel=\"noopener\">Cara mengurangi dua kolom dalam tabel pivot di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/tabel-pivot-excel-rata-rata-tertimbang\/\" target=\"_blank\" rel=\"noopener\">Cara menghitung rata-rata tertimbang dalam tabel pivot di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Contoh langkah demi langkah berikut ini memperlihatkan cara menghitung perbedaan persentase antara dua kolom dalam tabel pivot di Excel. Langkah 1: Masukkan datanya Mari kita mulai dengan memasukkan data penjualan berikut untuk tiga toko berbeda: Langkah 2: Buat PivotTable Selanjutnya, mari buat tabel pivot berikut untuk merangkum total penjualan menurut toko dan tahun: Langkah 3: [&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: Temukan perbedaan persentase antara dua kolom dalam tabel pivot - Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung persentase perbedaan antara dua kolom dalam tabel pivot 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\/perbedaan-persentase-tabel-pivot-excel-antara-dua-kolom\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel: Temukan perbedaan persentase antara dua kolom dalam tabel pivot - Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung persentase perbedaan antara dua kolom dalam tabel pivot di Excel, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/perbedaan-persentase-tabel-pivot-excel-antara-dua-kolom\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-17T01:43:53+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/diff1-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=\"1 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/perbedaan-persentase-tabel-pivot-excel-antara-dua-kolom\/\",\"url\":\"https:\/\/statorials.org\/id\/perbedaan-persentase-tabel-pivot-excel-antara-dua-kolom\/\",\"name\":\"Excel: Temukan perbedaan persentase antara dua kolom dalam tabel pivot - Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-17T01:43:53+00:00\",\"dateModified\":\"2023-07-17T01:43:53+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung persentase perbedaan antara dua kolom dalam tabel pivot di Excel, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/perbedaan-persentase-tabel-pivot-excel-antara-dua-kolom\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/perbedaan-persentase-tabel-pivot-excel-antara-dua-kolom\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/perbedaan-persentase-tabel-pivot-excel-antara-dua-kolom\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel: temukan perbedaan persentase antara dua kolom dalam tabel pivot\"}]},{\"@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: Temukan perbedaan persentase antara dua kolom dalam tabel pivot - Statorial","description":"Tutorial ini menjelaskan cara menghitung persentase perbedaan antara dua kolom dalam tabel pivot 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\/perbedaan-persentase-tabel-pivot-excel-antara-dua-kolom\/","og_locale":"id_ID","og_type":"article","og_title":"Excel: Temukan perbedaan persentase antara dua kolom dalam tabel pivot - Statorial","og_description":"Tutorial ini menjelaskan cara menghitung persentase perbedaan antara dua kolom dalam tabel pivot di Excel, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/perbedaan-persentase-tabel-pivot-excel-antara-dua-kolom\/","og_site_name":"Statorials","article_published_time":"2023-07-17T01:43:53+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/diff1-1.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\/perbedaan-persentase-tabel-pivot-excel-antara-dua-kolom\/","url":"https:\/\/statorials.org\/id\/perbedaan-persentase-tabel-pivot-excel-antara-dua-kolom\/","name":"Excel: Temukan perbedaan persentase antara dua kolom dalam tabel pivot - Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-17T01:43:53+00:00","dateModified":"2023-07-17T01:43:53+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung persentase perbedaan antara dua kolom dalam tabel pivot di Excel, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/perbedaan-persentase-tabel-pivot-excel-antara-dua-kolom\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/perbedaan-persentase-tabel-pivot-excel-antara-dua-kolom\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/perbedaan-persentase-tabel-pivot-excel-antara-dua-kolom\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Excel: temukan perbedaan persentase antara dua kolom dalam tabel pivot"}]},{"@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\/3519"}],"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=3519"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3519\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3519"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3519"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3519"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}