{"id":2343,"date":"2023-07-22T16:48:51","date_gmt":"2023-07-22T16:48:51","guid":{"rendered":"https:\/\/statorials.org\/id\/bidang-google-sheet-menghitung\/"},"modified":"2023-07-22T16:48:51","modified_gmt":"2023-07-22T16:48:51","slug":"bidang-google-sheet-menghitung","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/bidang-google-sheet-menghitung\/","title":{"rendered":"Google spreadsheet: cara menambahkan bidang terhitung ke tabel pivot"},"content":{"rendered":"

<\/p>\n

\n

Contoh langkah demi langkah berikut menunjukkan cara menambahkan bidang terhitung ke tabel pivot di Google Spreadsheet.<\/span><\/p>\n

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

Pertama, masukkan data berikut yang menunjukkan total pendapatan yang dihasilkan oleh produk tertentu di wilayah tertentu untuk suatu perusahaan:<\/span> <\/p>\n

\"\"<\/p>\n

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

Untuk membuat PivotTable yang merangkum total pendapatan menurut wilayah, klik tab Sisipkan<\/b> , lalu PivotTable<\/strong> :<\/span> <\/p>\n

\"\"<\/p>\n

Di jendela yang muncul, masukkan rentang data yang akan digunakan untuk tabel pivot dan pilih sel dari lembar yang ada untuk menempatkan tabel pivot:<\/span> <\/p>\n

\"\"<\/p>\n

Setelah Anda mengklik Buat<\/strong> , tabel pivot kosong akan dimasukkan secara otomatis.<\/span><\/p>\n

Di Editor PivotTable<\/strong> yang muncul di sisi kanan layar, klik Tambahkan<\/strong> di samping Baris<\/strong> dan pilih Wilayah<\/strong> . Kemudian klik Tambah<\/strong> di sebelah Nilai<\/strong> dan klik Pendapatan<\/strong> :<\/span> <\/p>\n

\"\"<\/p>\n

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

\"\"<\/p>\n

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

Katakanlah kita ingin menambahkan kolom kalkulasi ke tabel pivot yang menunjukkan total pajak penghasilan yang dibayarkan berdasarkan wilayah.<\/span><\/p>\n

Untuk menambahkan bidang terhitung ini, klik sel mana pun di tabel pivot. Di Editor PivotTable<\/strong> yang muncul di sisi kanan layar, klik Tambah<\/strong> di sebelah Nilai<\/strong> dan pilih Bidang Terhitung<\/strong> :<\/span> <\/p>\n

\"\"<\/p>\n

Di kolom Formula<\/strong> , ketik Pendapatan\/3<\/strong> lalu tekan Enter<\/strong> :<\/span> <\/p>\n

\"\"<\/p>\n

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

\"\"<\/p>\n

Jangan ragu untuk mengklik judul Bidang Terhitung dan masukkan nama lain:<\/span> <\/p>\n

\"\"<\/p>\n

Anda dapat menggunakan proses yang sama untuk menambahkan kolom kalkulasi sebanyak yang Anda inginkan ke tabel pivot.<\/span><\/p>\n

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

Tutorial berikut menjelaskan cara melakukan hal umum lainnya di Google Spreadsheet:<\/span><\/p>\n

Google Spreadsheet: Cara Memformat PivotTable<\/a>
Google Spreadsheet: Cara Membuat PivotTable dari Beberapa Lembar<\/a>
Kueri Google Spreadsheet: Cara Membuat PivotTable<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

Contoh langkah demi langkah berikut menunjukkan cara menambahkan bidang terhitung ke tabel pivot di Google Spreadsheet. Langkah 1: Masukkan datanya Pertama, masukkan data berikut yang menunjukkan total pendapatan yang dihasilkan oleh produk tertentu di wilayah tertentu untuk suatu perusahaan: Langkah 2: Buat tabel pivot Untuk membuat PivotTable yang merangkum total pendapatan menurut wilayah, klik tab […]<\/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":"\nGoogle Spreadsheet: Cara menambahkan bidang terhitung ke tabel pivot - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menambahkan kolom terhitung ke tabel pivot di Google Spreadsheet, dengan 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\/bidang-google-sheet-menghitung\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Google Spreadsheet: Cara menambahkan bidang terhitung ke tabel pivot - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menambahkan kolom terhitung ke tabel pivot di Google Spreadsheet, dengan contoh langkah demi langkah.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/bidang-google-sheet-menghitung\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-22T16:48:51+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pivot11.png\" \/>\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\/bidang-google-sheet-menghitung\/\",\"url\":\"https:\/\/statorials.org\/id\/bidang-google-sheet-menghitung\/\",\"name\":\"Google Spreadsheet: Cara menambahkan bidang terhitung ke tabel pivot - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-22T16:48:51+00:00\",\"dateModified\":\"2023-07-22T16:48:51+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menambahkan kolom terhitung ke tabel pivot di Google Spreadsheet, dengan contoh langkah demi langkah.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/bidang-google-sheet-menghitung\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/bidang-google-sheet-menghitung\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/bidang-google-sheet-menghitung\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Google spreadsheet: cara menambahkan bidang terhitung ke 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":"Google Spreadsheet: Cara menambahkan bidang terhitung ke tabel pivot - Statorials","description":"Tutorial ini menjelaskan cara menambahkan kolom terhitung ke tabel pivot di Google Spreadsheet, dengan 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\/bidang-google-sheet-menghitung\/","og_locale":"id_ID","og_type":"article","og_title":"Google Spreadsheet: Cara menambahkan bidang terhitung ke tabel pivot - Statorials","og_description":"Tutorial ini menjelaskan cara menambahkan kolom terhitung ke tabel pivot di Google Spreadsheet, dengan contoh langkah demi langkah.","og_url":"https:\/\/statorials.org\/id\/bidang-google-sheet-menghitung\/","og_site_name":"Statorials","article_published_time":"2023-07-22T16:48:51+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pivot11.png"}],"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\/bidang-google-sheet-menghitung\/","url":"https:\/\/statorials.org\/id\/bidang-google-sheet-menghitung\/","name":"Google Spreadsheet: Cara menambahkan bidang terhitung ke tabel pivot - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-22T16:48:51+00:00","dateModified":"2023-07-22T16:48:51+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menambahkan kolom terhitung ke tabel pivot di Google Spreadsheet, dengan contoh langkah demi langkah.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/bidang-google-sheet-menghitung\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/bidang-google-sheet-menghitung\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/bidang-google-sheet-menghitung\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Google spreadsheet: cara menambahkan bidang terhitung ke 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\/2343"}],"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=2343"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2343\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2343"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2343"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2343"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}