{"id":3762,"date":"2023-07-15T16:57:53","date_gmt":"2023-07-15T16:57:53","guid":{"rendered":"https:\/\/statorials.org\/id\/nomor-tabel-pivot-google-sheet\/"},"modified":"2023-07-15T16:57:53","modified_gmt":"2023-07-15T16:57:53","slug":"nomor-tabel-pivot-google-sheet","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/nomor-tabel-pivot-google-sheet\/","title":{"rendered":"Google spreadsheet: buat pivottable dengan jumlah kemunculan"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Contoh langkah demi langkah berikut menunjukkan cara membuat tabel pivot di Google Spreadsheet yang menampilkan jumlah kemunculan nilai.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 1: Masukkan datanya<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Pertama, masukkan data berikut yang menunjukkan total pendapatan yang dihasilkan oleh produk tertentu di wilayah tertentu untuk suatu perusahaan:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-21247 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pivot11.png\" alt=\"\" width=\"520\" height=\"460\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 2: Buat tabel pivot<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Untuk membuat PivotTable yang merangkum kumpulan data ini, klik tab <b>Sisipkan<\/b> lalu klik <strong>PivotTable<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-30645 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pivot1.jpg\" alt=\"\" width=\"508\" height=\"564\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">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><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-21249 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pivot13.png\" alt=\"\" width=\"359\" height=\"377\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Setelah Anda mengklik <strong>Buat<\/strong> , tabel pivot kosong akan dimasukkan secara otomatis.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Di <strong>Editor PivotTable<\/strong> yang muncul di sisi kanan layar, klik <strong>Tambahkan<\/strong> di samping <strong>Baris<\/strong> dan pilih <strong>Wilayah<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kemudian klik <strong>Tambah<\/strong> di sebelah <b>Garis<\/b> dan klik <strong>Produk<\/strong> :<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kemudian klik <strong>Tambah<\/strong> di sebelah <strong>Nilai<\/strong> dan klik <strong>Pendapatan<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-30649 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pivot3-1.jpg\" alt=\"\" width=\"345\" height=\"735\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Secara default, tabel pivot akan mencoba merangkum nilai pendapatan menggunakan <strong>SUM<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk menampilkan <strong>COUNT<\/strong> pendapatan, klik panah tarik-turun di bawah <strong>Ringkas menurut<\/strong> dan klik <strong>COUNT<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-30650 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pivot4.jpg\" alt=\"\" width=\"343\" height=\"567\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Tabel pivot akan diperbarui untuk menampilkan jumlah kemunculan berdasarkan wilayah dan produk:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-30651\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pivot5.jpg\" alt=\"Jumlah Kemunculan PivotTable Google Spreadsheet\" width=\"409\" height=\"460\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, kita dapat melihat:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Produk Telah muncul <strong>2<\/strong> kali di wilayah Timur.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Produk B muncul <strong>1<\/strong> kali di wilayah Timur.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Produk C muncul <strong>1<\/strong> kali di wilayah Timur.<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Dan seterusnya.<\/span><\/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 hal umum lainnya di Google Spreadsheet:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/memformat-tabel-pivot-google-sheet\/\" target=\"_blank\" rel=\"noopener\">Google Spreadsheet: Cara Memformat PivotTable<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/persentase-tabel-pivot-google-sheet-dari-total\/\" target=\"_blank\" rel=\"noopener\">Google Spreadsheet: Tampilkan persentase total dalam tabel pivot<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/tabel-pivot-lembar-google-tab-silang-beberapa-lembar\/\" target=\"_blank\" rel=\"noopener\">Google Spreadsheet: Cara Membuat PivotTable dari Beberapa Lembar<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Contoh langkah demi langkah berikut menunjukkan cara membuat tabel pivot di Google Spreadsheet yang menampilkan jumlah kemunculan nilai. 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 kumpulan data ini, klik [&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>Google Spreadsheet: Buat PivotTable dengan Jumlah Kemunculan \u2013 Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara membuat tabel pivot di Google Sheets dengan jumlah kemunculan setiap nilai, beserta 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\/nomor-tabel-pivot-google-sheet\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Google Spreadsheet: Buat PivotTable dengan Jumlah Kemunculan \u2013 Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara membuat tabel pivot di Google Sheets dengan jumlah kemunculan setiap nilai, beserta sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/nomor-tabel-pivot-google-sheet\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-15T16:57:53+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\/nomor-tabel-pivot-google-sheet\/\",\"url\":\"https:\/\/statorials.org\/id\/nomor-tabel-pivot-google-sheet\/\",\"name\":\"Google Spreadsheet: Buat PivotTable dengan Jumlah Kemunculan \u2013 Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-15T16:57:53+00:00\",\"dateModified\":\"2023-07-15T16:57:53+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara membuat tabel pivot di Google Sheets dengan jumlah kemunculan setiap nilai, beserta sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/nomor-tabel-pivot-google-sheet\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/nomor-tabel-pivot-google-sheet\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/nomor-tabel-pivot-google-sheet\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Google spreadsheet: buat pivottable dengan jumlah kemunculan\"}]},{\"@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: Buat PivotTable dengan Jumlah Kemunculan \u2013 Statorial","description":"Tutorial ini menjelaskan cara membuat tabel pivot di Google Sheets dengan jumlah kemunculan setiap nilai, beserta 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\/nomor-tabel-pivot-google-sheet\/","og_locale":"id_ID","og_type":"article","og_title":"Google Spreadsheet: Buat PivotTable dengan Jumlah Kemunculan \u2013 Statorial","og_description":"Tutorial ini menjelaskan cara membuat tabel pivot di Google Sheets dengan jumlah kemunculan setiap nilai, beserta sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/nomor-tabel-pivot-google-sheet\/","og_site_name":"Statorials","article_published_time":"2023-07-15T16:57:53+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\/nomor-tabel-pivot-google-sheet\/","url":"https:\/\/statorials.org\/id\/nomor-tabel-pivot-google-sheet\/","name":"Google Spreadsheet: Buat PivotTable dengan Jumlah Kemunculan \u2013 Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-15T16:57:53+00:00","dateModified":"2023-07-15T16:57:53+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara membuat tabel pivot di Google Sheets dengan jumlah kemunculan setiap nilai, beserta sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/nomor-tabel-pivot-google-sheet\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/nomor-tabel-pivot-google-sheet\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/nomor-tabel-pivot-google-sheet\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Google spreadsheet: buat pivottable dengan jumlah kemunculan"}]},{"@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\/3762"}],"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=3762"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3762\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3762"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3762"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3762"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}