{"id":3521,"date":"2023-07-17T01:28:51","date_gmt":"2023-07-17T01:28:51","guid":{"rendered":"https:\/\/statorials.org\/id\/tabel-pivot-excel-hapus-perhitungan-bidang\/"},"modified":"2023-07-17T01:28:51","modified_gmt":"2023-07-17T01:28:51","slug":"tabel-pivot-excel-hapus-perhitungan-bidang","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/tabel-pivot-excel-hapus-perhitungan-bidang\/","title":{"rendered":"Excel: cara menghapus bidang terhitung dalam tabel pivot"},"content":{"rendered":"

<\/p>\n

\n

Contoh langkah demi langkah berikut ini memperlihatkan cara menghapus bidang terhitung dari tabel pivot di Excel.<\/span><\/p>\n

Langkah 1: Buat tabel pivot<\/strong><\/span><\/h2>\n

Misalkan kita membuat tabel pivot berikut yang merangkum total penjualan dan pengembalian di tiga toko berbeda:<\/span> <\/p>\n

\"\"<\/p>\n

Langkah 2: Tambahkan bidang terhitung ke tabel pivot<\/strong><\/span><\/h2>\n

Katakanlah kita ingin membuat kolom baru di tabel pivot yang menampilkan jumlah kolom Jumlah Penjualan<\/strong> dan Jumlah Pengembalian<\/strong> .<\/span><\/p>\n

Untuk melakukan ini, kita perlu menambahkan bidang terhitung ke PivotTable dengan mengklik nilai apa pun di PivotTable, lalu mengklik tab Analisis PivotTable<\/strong> , lalu mengklik Bidang, Item & Kumpulan<\/strong> , lalu pada Bidang terhitung<\/strong> :<\/span> <\/p>\n

\"\"<\/p>\n

Pada jendela baru yang muncul, ketik \u201cTotal Transaksi\u201d pada kolom Nama, lalu ketik =Penjualan + Pengembalian<\/strong> pada kolom Rumus.<\/span><\/p>\n

Lalu klik Tambah<\/strong> , lalu klik OK<\/strong> .<\/span> <\/p>\n

\"Tabel<\/p>\n

Bidang terhitung ini akan secara otomatis ditambahkan ke tabel pivot:<\/span> <\/p>\n

\"\"<\/p>\n

Langkah 3: Hapus bidang kalkulasi dari tabel pivot<\/strong><\/span><\/h2>\n

Sekarang katakanlah kita ingin menghapus kolom kalkulasi dari tabel pivot.<\/span><\/p>\n

Untuk melakukan ini, kita dapat mengklik lagi tombol sisipkan kolom kalkulasi<\/strong> :<\/span> <\/p>\n

\"\"<\/p>\n

Di jendela yang muncul, pilih Total Transaksi<\/strong> dari menu drop-down Nama.<\/span><\/p>\n

Kemudian klik tombol Hapus<\/strong> , lalu klik OK<\/strong> :<\/span> <\/p>\n

\"\"<\/p>\n

Bidang terhitung akan dihapus dari tabel pivot:<\/span> <\/p>\n

\"\"<\/p>\n

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

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

Bagaimana cara menambahkan dua kolom ke tabel pivot di Excel<\/a>
Cara mengurangi dua kolom dalam tabel pivot di Excel<\/a>
Excel: Temukan perbedaan persentase antara dua kolom dalam tabel pivot<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

Contoh langkah demi langkah berikut ini memperlihatkan cara menghapus bidang terhitung dari tabel pivot di Excel. Langkah 1: Buat tabel pivot Misalkan kita membuat tabel pivot berikut yang merangkum total penjualan dan pengembalian di tiga toko berbeda: Langkah 2: Tambahkan bidang terhitung ke tabel pivot Katakanlah kita ingin membuat kolom baru di tabel pivot yang […]<\/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 menghapus kolom kalkulasi di tabel pivot - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghapus bidang terhitung dari 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\/tabel-pivot-excel-hapus-perhitungan-bidang\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel: Cara menghapus kolom kalkulasi di tabel pivot - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghapus bidang terhitung dari tabel pivot di Excel, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/tabel-pivot-excel-hapus-perhitungan-bidang\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-17T01:28:51+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/soustraire4.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-hapus-perhitungan-bidang\/\",\"url\":\"https:\/\/statorials.org\/id\/tabel-pivot-excel-hapus-perhitungan-bidang\/\",\"name\":\"Excel: Cara menghapus kolom kalkulasi di tabel pivot - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-17T01:28:51+00:00\",\"dateModified\":\"2023-07-17T01:28:51+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghapus bidang terhitung dari tabel pivot di Excel, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/tabel-pivot-excel-hapus-perhitungan-bidang\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/tabel-pivot-excel-hapus-perhitungan-bidang\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/tabel-pivot-excel-hapus-perhitungan-bidang\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel: cara menghapus bidang terhitung 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: Cara menghapus kolom kalkulasi di tabel pivot - Statorials","description":"Tutorial ini menjelaskan cara menghapus bidang terhitung dari 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\/tabel-pivot-excel-hapus-perhitungan-bidang\/","og_locale":"id_ID","og_type":"article","og_title":"Excel: Cara menghapus kolom kalkulasi di tabel pivot - Statorials","og_description":"Tutorial ini menjelaskan cara menghapus bidang terhitung dari tabel pivot di Excel, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/tabel-pivot-excel-hapus-perhitungan-bidang\/","og_site_name":"Statorials","article_published_time":"2023-07-17T01:28:51+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/soustraire4.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-hapus-perhitungan-bidang\/","url":"https:\/\/statorials.org\/id\/tabel-pivot-excel-hapus-perhitungan-bidang\/","name":"Excel: Cara menghapus kolom kalkulasi di tabel pivot - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-17T01:28:51+00:00","dateModified":"2023-07-17T01:28:51+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghapus bidang terhitung dari tabel pivot di Excel, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/tabel-pivot-excel-hapus-perhitungan-bidang\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/tabel-pivot-excel-hapus-perhitungan-bidang\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/tabel-pivot-excel-hapus-perhitungan-bidang\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Excel: cara menghapus bidang terhitung 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\/3521"}],"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=3521"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3521\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3521"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3521"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3521"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}