{"id":2658,"date":"2023-07-21T07:35:33","date_gmt":"2023-07-21T07:35:33","guid":{"rendered":"https:\/\/statorials.org\/id\/lembar-grup-google-per-bulan\/"},"modified":"2023-07-21T07:35:33","modified_gmt":"2023-07-21T07:35:33","slug":"lembar-grup-google-per-bulan","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/lembar-grup-google-per-bulan\/","title":{"rendered":"Cara mengelompokkan data berdasarkan bulan di google sheets (dengan contoh)"},"content":{"rendered":"

<\/p>\n

\n

Seringkali Anda mungkin ingin mengelompokkan data berdasarkan bulan di Google Spreadsheet.<\/span><\/p>\n

Untungnya, hal ini mudah dilakukan menggunakan fitur grup tanggal pivot<\/strong> di tabel pivot.<\/span><\/p>\n

Contoh langkah demi langkah berikut menunjukkan cara menggunakan fungsi ini untuk mengelompokkan data berdasarkan bulan di Google Spreadsheet.<\/span><\/p>\n

Langkah 1: Buat datanya<\/strong><\/span><\/h3>\n

Pertama, mari buat kumpulan data yang menunjukkan total penjualan yang dilakukan suatu bisnis pada hari yang berbeda:<\/span> <\/p>\n

\"\"<\/p>\n

Langkah 2: Buat PivotTable<\/strong><\/span><\/h3>\n

Selanjutnya, sorot sel dalam rentang A1:B12<\/strong> , lalu klik tab Sisipkan<\/strong> di sepanjang pita atas dan klik PivotTable<\/strong> .<\/span> <\/p>\n

\"\"<\/p>\n

Selanjutnya, kita akan memilih untuk memasukkan tabel pivot ke dalam lembar kerja saat ini di sel D1:<\/span> <\/p>\n

\"\"<\/p>\n

Di Editor PivotTable<\/strong> di sisi kanan layar, pilih Tanggal untuk Baris<\/strong> dan Penjualan untuk Nilai<\/strong> :<\/span> <\/p>\n

\"\"<\/p>\n

Nilai tabel pivot sekarang akan terisi.<\/span><\/p>\n

Langkah 3: Kelompokkan data berdasarkan bulan<\/strong><\/span><\/h3>\n

Untuk mengelompokkan data menurut bulan, klik kanan nilai apa pun di kolom Tanggal PivotTable dan klik Buat Grup Tanggal Pivot<\/strong> , lalu klik Bulan<\/strong> :<\/span> <\/p>\n

\"Google<\/p>\n

Data tabel pivot secara otomatis akan dikelompokkan berdasarkan bulan:<\/span> <\/p>\n

\"\"<\/p>\n

PivotTable sekarang menampilkan jumlah penjualan yang dikelompokkan berdasarkan bulan.<\/span><\/p>\n

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

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

Google Sheets: cara memfilter sel yang berisi teks<\/a>
Google Sheets: Cara menggunakan SUMIF dengan banyak kolom<\/a>
Google Spreadsheet: cara menambahkan beberapa lembar<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

Seringkali Anda mungkin ingin mengelompokkan data berdasarkan bulan di Google Spreadsheet. Untungnya, hal ini mudah dilakukan menggunakan fitur grup tanggal pivot di tabel pivot. Contoh langkah demi langkah berikut menunjukkan cara menggunakan fungsi ini untuk mengelompokkan data berdasarkan bulan di Google Spreadsheet. Langkah 1: Buat datanya Pertama, mari buat kumpulan data yang menunjukkan total penjualan […]<\/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":"\nCara Mengelompokkan Data Berdasarkan Bulan di Google Sheets (dengan Contoh) - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mengelompokkan data berdasarkan bulan di Google Sheets, beserta contoh lengkapnya.\" \/>\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\/lembar-grup-google-per-bulan\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Mengelompokkan Data Berdasarkan Bulan di Google Sheets (dengan Contoh) - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mengelompokkan data berdasarkan bulan di Google Sheets, beserta contoh lengkapnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/lembar-grup-google-per-bulan\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-21T07:35:33+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/groupemois1.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\/lembar-grup-google-per-bulan\/\",\"url\":\"https:\/\/statorials.org\/id\/lembar-grup-google-per-bulan\/\",\"name\":\"Cara Mengelompokkan Data Berdasarkan Bulan di Google Sheets (dengan Contoh) - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-21T07:35:33+00:00\",\"dateModified\":\"2023-07-21T07:35:33+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mengelompokkan data berdasarkan bulan di Google Sheets, beserta contoh lengkapnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/lembar-grup-google-per-bulan\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/lembar-grup-google-per-bulan\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/lembar-grup-google-per-bulan\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara mengelompokkan data berdasarkan bulan di google sheets (dengan contoh)\"}]},{\"@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":"Cara Mengelompokkan Data Berdasarkan Bulan di Google Sheets (dengan Contoh) - Statologi","description":"Tutorial ini menjelaskan cara mengelompokkan data berdasarkan bulan di Google Sheets, beserta contoh lengkapnya.","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\/lembar-grup-google-per-bulan\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Mengelompokkan Data Berdasarkan Bulan di Google Sheets (dengan Contoh) - Statologi","og_description":"Tutorial ini menjelaskan cara mengelompokkan data berdasarkan bulan di Google Sheets, beserta contoh lengkapnya.","og_url":"https:\/\/statorials.org\/id\/lembar-grup-google-per-bulan\/","og_site_name":"Statorials","article_published_time":"2023-07-21T07:35:33+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/groupemois1.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\/lembar-grup-google-per-bulan\/","url":"https:\/\/statorials.org\/id\/lembar-grup-google-per-bulan\/","name":"Cara Mengelompokkan Data Berdasarkan Bulan di Google Sheets (dengan Contoh) - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-21T07:35:33+00:00","dateModified":"2023-07-21T07:35:33+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mengelompokkan data berdasarkan bulan di Google Sheets, beserta contoh lengkapnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/lembar-grup-google-per-bulan\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/lembar-grup-google-per-bulan\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/lembar-grup-google-per-bulan\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara mengelompokkan data berdasarkan bulan di google sheets (dengan contoh)"}]},{"@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\/2658"}],"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=2658"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2658\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2658"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2658"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2658"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}