{"id":1695,"date":"2023-07-25T08:42:37","date_gmt":"2023-07-25T08:42:37","guid":{"rendered":"https:\/\/statorials.org\/id\/kueri-pivot-lembar-google\/"},"modified":"2023-07-25T08:42:37","modified_gmt":"2023-07-25T08:42:37","slug":"kueri-pivot-lembar-google","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/kueri-pivot-lembar-google\/","title":{"rendered":"Kueri google spreadsheet: cara membuat pivottable"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan sintaks berikut untuk membuat tabel pivot menggunakan kueri Google Spreadsheet:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span class=\" string \" dir=\"auto\"><span class=\" default-formula-text-color\" dir=\"auto\">=<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">query<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">(<\/span> <span dir=\"auto\" style=\"color: #ff9900;\">A1:C13<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">,<\/span> \" <span style=\"color: #008000;\">select A, sum(C) group by A pivot B<\/span> \" <span class=\" default-formula-text-color\" dir=\"auto\">)<\/span><\/span>\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Dalam contoh ini, kita memilih kolom <strong>A<\/strong> untuk mewakili baris tabel pivot, kolom <strong>B<\/strong> untuk mewakili kolom tabel pivot, dan nilai di kolom <strong>C<\/strong> untuk ditampilkan di tabel pivot.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 1: Buat PivotTable menggunakan SUM()<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan rumus berikut untuk membuat tabel pivot yang menampilkan total penjualan berdasarkan produk dan wilayah untuk perusahaan tertentu:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-16710 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/piv1-1.png\" alt=\"\" width=\"629\" height=\"475\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kami akan menafsirkan nilai tabel pivot sebagai berikut:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Total penjualan produk A di wilayah Timur sebanyak <strong>388<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">Total penjualan produk B di wilayah Timur adalah <strong>0<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">Total penjualan Produk C di wilayah Timur sebanyak <strong>476<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">Total penjualan produk D di wilayah Timur adalah <strong>0<\/strong> .<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Dan seterusnya.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 2: Membuat PivotTable menggunakan AVG()<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan rumus berikut untuk membuat tabel pivot yang menampilkan rata-rata penjualan berdasarkan produk dan wilayah untuk perusahaan tertentu:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-16711 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/piv2.png\" alt=\"\" width=\"620\" height=\"442\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kami akan menafsirkan nilai tabel pivot sebagai berikut:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Rata-rata penjualan produk A di wilayah Timur adalah <strong>388<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">Rata-rata penjualan produk B di wilayah Timur adalah <strong>0<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">Rata-rata penjualan produk C di wilayah Timur adalah <strong>238<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">Rata-rata penjualan produk D di wilayah Timur adalah <strong>0<\/strong> .<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Dan seterusnya.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> <a href=\"https:\/\/statorials.org\/id\/kueri-google-sheet-pilih-beberapa-kolom\/\" target=\"_blank\" rel=\"noopener\">Kueri Google Spreadsheet: cara memilih beberapa kolom<\/a><br \/><a href=\"https:\/\/statorials.org\/id\/grup-kueri-google-sheet-menurut\/\" target=\"_blank\" rel=\"noopener\">Kueri Google Spreadsheet: Cara Menggunakan Grup Berdasarkan<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/permintaan-kueri-google-sheets-diurutkan-berdasarkan\/\" target=\"_blank\" rel=\"noopener\">Kueri Google Spreadsheet: Cara Menggunakan Sortir Berdasarkan<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan sintaks berikut untuk membuat tabel pivot menggunakan kueri Google Spreadsheet: = query ( A1:C13 , &#8221; select A, sum(C) group by A pivot B &#8221; ) Dalam contoh ini, kita memilih kolom A untuk mewakili baris tabel pivot, kolom B untuk mewakili kolom tabel pivot, dan nilai di kolom C untuk ditampilkan [&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>Kueri Google Spreadsheet: Cara Membuat PivotTable<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggunakan fungsi PIVOT() di Kueri Google Sheets, dengan beberapa 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\/kueri-pivot-lembar-google\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Kueri Google Spreadsheet: Cara Membuat PivotTable\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggunakan fungsi PIVOT() di Kueri Google Sheets, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/kueri-pivot-lembar-google\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-25T08:42:37+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/piv1-1.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\/kueri-pivot-lembar-google\/\",\"url\":\"https:\/\/statorials.org\/id\/kueri-pivot-lembar-google\/\",\"name\":\"Kueri Google Spreadsheet: Cara Membuat PivotTable\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-25T08:42:37+00:00\",\"dateModified\":\"2023-07-25T08:42:37+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggunakan fungsi PIVOT() di Kueri Google Sheets, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/kueri-pivot-lembar-google\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/kueri-pivot-lembar-google\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/kueri-pivot-lembar-google\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Kueri google spreadsheet: cara membuat pivottable\"}]},{\"@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":"Kueri Google Spreadsheet: Cara Membuat PivotTable","description":"Tutorial ini menjelaskan cara menggunakan fungsi PIVOT() di Kueri Google Sheets, dengan beberapa 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\/kueri-pivot-lembar-google\/","og_locale":"id_ID","og_type":"article","og_title":"Kueri Google Spreadsheet: Cara Membuat PivotTable","og_description":"Tutorial ini menjelaskan cara menggunakan fungsi PIVOT() di Kueri Google Sheets, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/kueri-pivot-lembar-google\/","og_site_name":"Statorials","article_published_time":"2023-07-25T08:42:37+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/piv1-1.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\/kueri-pivot-lembar-google\/","url":"https:\/\/statorials.org\/id\/kueri-pivot-lembar-google\/","name":"Kueri Google Spreadsheet: Cara Membuat PivotTable","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-25T08:42:37+00:00","dateModified":"2023-07-25T08:42:37+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggunakan fungsi PIVOT() di Kueri Google Sheets, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/kueri-pivot-lembar-google\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/kueri-pivot-lembar-google\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/kueri-pivot-lembar-google\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Kueri google spreadsheet: cara membuat pivottable"}]},{"@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\/1695"}],"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=1695"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/1695\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=1695"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=1695"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=1695"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}