{"id":3763,"date":"2023-07-15T16:49:27","date_gmt":"2023-07-15T16:49:27","guid":{"rendered":"https:\/\/statorials.org\/id\/nomor-tunggal-tabel-pivot-google-sheet\/"},"modified":"2023-07-15T16:49:27","modified_gmt":"2023-07-15T16:49:27","slug":"nomor-tunggal-tabel-pivot-google-sheet","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/nomor-tunggal-tabel-pivot-google-sheet\/","title":{"rendered":"Google spreadsheet: buat pivottable dengan hitungan unik"},"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 nilai unik suatu variabel.<\/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;\">Lalu klik <strong>Tambah<\/strong> di sebelah <b>Nilai<\/b> dan klik <strong>Produk<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Secara default, Google Spreadsheet akan memilih <strong>COUNTA<\/strong> sebagai cara untuk meringkas nilai produk:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-30656 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/piv1.jpg\" alt=\"\" width=\"348\" height=\"630\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Untuk melihat jumlah unik produk berdasarkan wilayah, klik panah tarik-turun di bawah <strong>Ringkas menurut<\/strong> dan klik <strong>COUNTUNIQUE<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-30657\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/piv2.jpg\" alt=\"Jumlah tabel pivot Google Spreadsheet unik\" width=\"326\" height=\"568\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Tabel pivot akan diperbarui untuk menampilkan jumlah unik produk berdasarkan wilayah:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-30658 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/piv3.jpg\" alt=\"\" width=\"357\" height=\"225\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, kita dapat melihat:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Ada 3 produk unik di wilayah Timur.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Ada 3 produk unik di wilayah Utara.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Ada 3 produk unik di wilayah Selatan.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Ada 3 produk unik di wilayah Barat.<\/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 nilai unik suatu variabel. 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 [&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: Membuat PivotTable dengan Hitungan Unik \u2013 Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara membuat tabel pivot di Google Spreadsheet dan menghitung jumlah kemunculan nilai unik.\" \/>\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-tunggal-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: Membuat PivotTable dengan Hitungan Unik \u2013 Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara membuat tabel pivot di Google Spreadsheet dan menghitung jumlah kemunculan nilai unik.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/nomor-tunggal-tabel-pivot-google-sheet\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-15T16:49:27+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-tunggal-tabel-pivot-google-sheet\/\",\"url\":\"https:\/\/statorials.org\/id\/nomor-tunggal-tabel-pivot-google-sheet\/\",\"name\":\"Google Spreadsheet: Membuat PivotTable dengan Hitungan Unik \u2013 Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-15T16:49:27+00:00\",\"dateModified\":\"2023-07-15T16:49:27+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara membuat tabel pivot di Google Spreadsheet dan menghitung jumlah kemunculan nilai unik.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/nomor-tunggal-tabel-pivot-google-sheet\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/nomor-tunggal-tabel-pivot-google-sheet\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/nomor-tunggal-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 hitungan unik\"}]},{\"@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: Membuat PivotTable dengan Hitungan Unik \u2013 Statorial","description":"Tutorial ini menjelaskan cara membuat tabel pivot di Google Spreadsheet dan menghitung jumlah kemunculan nilai unik.","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-tunggal-tabel-pivot-google-sheet\/","og_locale":"id_ID","og_type":"article","og_title":"Google Spreadsheet: Membuat PivotTable dengan Hitungan Unik \u2013 Statorial","og_description":"Tutorial ini menjelaskan cara membuat tabel pivot di Google Spreadsheet dan menghitung jumlah kemunculan nilai unik.","og_url":"https:\/\/statorials.org\/id\/nomor-tunggal-tabel-pivot-google-sheet\/","og_site_name":"Statorials","article_published_time":"2023-07-15T16:49:27+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-tunggal-tabel-pivot-google-sheet\/","url":"https:\/\/statorials.org\/id\/nomor-tunggal-tabel-pivot-google-sheet\/","name":"Google Spreadsheet: Membuat PivotTable dengan Hitungan Unik \u2013 Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-15T16:49:27+00:00","dateModified":"2023-07-15T16:49:27+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara membuat tabel pivot di Google Spreadsheet dan menghitung jumlah kemunculan nilai unik.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/nomor-tunggal-tabel-pivot-google-sheet\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/nomor-tunggal-tabel-pivot-google-sheet\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/nomor-tunggal-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 hitungan unik"}]},{"@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\/3763"}],"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=3763"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3763\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3763"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3763"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3763"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}