{"id":1626,"date":"2023-11-15T05:22:32","date_gmt":"2023-11-15T05:22:32","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/menghitung-nilai-unik\/"},"modified":"2023-12-06T06:20:17","modified_gmt":"2023-12-06T06:20:17","slug":"menghitung-nilai-unik","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/menghitung-nilai-unik\/","title":{"rendered":"Hitung nilai unik dalam tabel pivot"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-4074663022\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div> <h2 class=\"wp-block-heading\">Menggunakan Model Data dengan PivotTable<\/h2><p> Model data adalah hal lain yang saya sukai tentang versi baru Microsoft Excel. Jika Anda menggunakan Excel untuk Microsoft 365, Excel 2019, Excel 2016, dan Excel 2013, Anda memiliki akses ke model data.<\/p><ol><li> Untuk memulai, klik sel mana pun di data dan navigasikan ke tab \u201cSisipkan\u201d di pita Anda. <br><img loading=\"lazy\" decoding=\"async\" title=\"1-buka-untuk-memasukkan-tab\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-aller-a-longlet-inserer.png\" sizes=\"auto, \" srcset=\"\" alt=\"go-to-insert-tab\" width=\"457\" height=\"151\"><\/li><li> Klik di sini pada tabel pivot dan kotak dialog muncul. <br><img loading=\"lazy\" decoding=\"async\" title=\"2-klik-pada-tabel-pivot-dialog-1\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-cliquez-sur-la-boite-de-dialogue-du-tableau-croise-dynamique-2.png\" sizes=\"auto, \" srcset=\"\" alt=\"click-on-pivot-table-dialogue-box\" width=\"437\" height=\"392\"><\/li><li> Sekarang centang kotak di bagian bawah kotak dialog, \u201cTambahkan data ini ke model data\u201d dan tekan OK.<\/li><li> Setelah itu, Anda akan mendapatkan tabel pivot seperti biasa dan mengatur data Anda di kolom tabel pivot seperti yang Anda lakukan sebelumnya. Ini akan memberi Anda tabel pivot yang sama dengan yang Anda miliki sebelumnya, namun bidang tabel pivot sedikit berbeda. <br><img loading=\"lazy\" decoding=\"async\" title=\"3-array-pivot-biasa-1\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-tableau-croise-dynamique-habituel-2.png\" sizes=\"auto, \" srcset=\"\" alt=\"usual-pivot-table\" width=\"599\" height=\"370\"><\/li><li> Begini caranya: Klik panah kecil di samping &#8220;Jumlah Penyedia Layanan&#8221; di bidang PivotTable. <br><img loading=\"lazy\" decoding=\"async\" title=\"4-jumlah-penyedia-layanan-1\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-nombre-de-fournisseur-de-services-2.png\" sizes=\"auto, \" srcset=\"\" alt=\"count-of-service-provider\" width=\"335\" height=\"199\"><\/li><li> Setelah itu, klik \u201cPengaturan Bidang Nilai\u201d. <br><img loading=\"lazy\" decoding=\"async\" title=\"Parameter bidang 5 nilai -1\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-parametres-de-champ-de-valeur-3.png\" sizes=\"auto, \" srcset=\"\" alt=\"value-field-settings\" width=\"194\" height=\"260\"><\/li><li> Sekarang gulir ke akhir untuk mendapatkan \u201cAkun Terpisah\u201d dan klik OK. <br><img loading=\"lazy\" decoding=\"async\" title=\"6-hitungan-berbeda-klik-ok-1\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-compte-distinct-cliquez-sur-ok-2.png\" sizes=\"auto, \" srcset=\"\" alt=\"distinct-count-click-ok\" width=\"396\" height=\"357\"><\/li><li> Ini dia: Anda memiliki nomor berbeda\/unik untuk setiap wilayah di tabel pivot. <br><img loading=\"lazy\" decoding=\"async\" title=\"7-nomor-beda-setiap-alasan-1\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/7-nombre-distinct-de-chaque-raison-2.png\" sizes=\"auto, \" srcset=\"\" alt=\"distinct-count-of-each-reason\" width=\"293\" height=\"117\"><\/li><\/ol><p> Oleh karena itu, kami hanya memiliki 18 penyedia layanan unik di negara ini.<\/p><h2 class=\"wp-block-heading\"> Menggunakan fungsi COUNTIF<\/h2><p> Pendekatan lain untuk menghitung entri unik adalah dengan menggunakan rumus COUNTIF di lembar data Anda.<\/p><ul><li> Mari kita mulai dengan menambahkan kolom ke data Anda dengan header pilihan Anda. Di sini kita akan menyebutnya \u201cHitungan Tidak\u201d.<\/li><li> Tambahkan rumus ini (=IF (COUNTIF ($B$2:B2,B2)&gt;1,0,1)) ke sel D2 dan seret hingga akhir. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-59147\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/8-en-utilisant-la-fonction-countif-2.png\" sizes=\"auto, \" srcset=\"\" alt=\"menggunakan fungsi countif\" width=\"310\" height=\"120\"><\/figure><\/div><h3 class=\"wp-block-heading\"> <strong>Bagaimana rumus ini bekerja??<\/strong><\/h3><p> Pertama, kita tetapkan titik awal rentang, disebut juga Absolut, yaitu $B$2. Artinya, rumus tidak akan berubah meskipun Anda menyeret rumus ke bawah. Sekarang saat Anda menyeret rumus ke bawah ke D3, rumus ini menjadi IF(COUNTIF($B$2:B3,B3)&gt;1,0,1)<\/p><p> Bacalah seperti itu<\/p><p> <strong>Countif<\/strong> ( <strong>$B$2:B3<\/strong> , <strong>B3<\/strong> ) akan memberi Anda berapa kali <strong>B3<\/strong> ada di antara rentang <strong>$B$2:B3.<\/strong> Fungsi IF digunakan untuk menambahkan kondisi: IF (( <strong>berapa kali B3 ada dalam rentang tertentu<\/strong> ) lebih besar dari 1, maka berikan 0 jika tidak, kembalikan 1)<\/p><p> Sekarang jika nama pada kolom yang diberikan keluar lebih dari satu kali maka rumusnya akan mengembalikan Anda 0 jika tidak, Anda akan mendapatkan 1. Oleh karena itu untuk semua nama yang berulang ini Anda akan mendapatkan 0 di kolom Hitung tanpa.<\/p><ol><li> Sekarang buat tabel pivot dengan data Anda. <br><img loading=\"lazy\" decoding=\"async\" title=\"9-buat-papan-poros-1\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/9-creer-un-tableau-croise-dynamique-2.png\" sizes=\"auto, \" srcset=\"\" alt=\"create-a-pivot-table\" width=\"433\" height=\"143\"><\/li><li> Di sini Anda perlu menambahkan nilai Lokasi ke ROWS dan Jumlah Jumlah. <br><img loading=\"lazy\" decoding=\"async\" title=\"10-tambahkan-lokasi-ke-jalur-1\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/10-ajouter-des-emplacements-a-la-rangee-2.png\" sizes=\"auto, \" srcset=\"\" alt=\"add-locations-to-the-row\" width=\"310\" height=\"386\"><\/li><li> Ledakan!! Tabel pivot sudah siap dengan entri unik di setiap tabel pivot. <br><img loading=\"lazy\" decoding=\"async\" title=\"11 tabel pivot dengan entri unik\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/11-tableau-croise-dynamique-avec-des-entrees-uniques-2.png\" sizes=\"auto, \" srcset=\"\" alt=\"pivot-table-with-unique-entries\" width=\"156\" height=\"141\"><\/li><\/ol><h2 class=\"wp-block-heading\"> Gunakan Power Pivot untuk menghitung nilai unik<\/h2><p> Berikut adalah metode paling ampuh untuk mengidentifikasi entri unik; Poros kekuatan. Pastikan Anda memiliki tab Power Pivot di pita Anda. Jika Anda tidak dapat menemukan tab tersebut, <a href=\"https:\/\/exceladvisor.org\/id\/aktifkan-poros-daya\/\" data-wpil=\"url\">lihat tutorial ini<\/a> .<\/p><ol><li> Seperti yang dikatakan sebelumnya, pertama-tama, pastikan tab Power Pivot diaktifkan. <br><img loading=\"lazy\" decoding=\"async\" title=\"12-kekuatan-pivot-untuk-menghitung-nilai-unik\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/12-pivots-de-puissance-pour-compter-les-valeurs-uniques.png\" sizes=\"auto, \" srcset=\"\" alt=\"power-pivot-to-count-unique-values\" width=\"612\" height=\"155\"><\/li><li> Setelah itu, buka model data dan klik <strong>tombol Kelola<\/strong> . <br><img loading=\"lazy\" decoding=\"async\" title=\"13-model-data-klik-tombol-kelola\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/13-modele-de-donnees-cliquez-sur-le-bouton-gerer.png\" sizes=\"auto, \" srcset=\"\" alt=\"data-model-click-manage-button\" width=\"608\" height=\"154\"><\/li><li> Di sini sebuah jendela akan terbuka, yang pasti akan kosong jika Anda baru pertama kali mengimpor data. <br><img loading=\"lazy\" decoding=\"async\" title=\"14-jendela-kosong-terbuka\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/14-fenetre-vierge-ouverte.png\" sizes=\"auto, \" srcset=\"\" alt=\"blank-window-opened\" width=\"652\" height=\"694\"><\/li><li> Klik Beranda \u2192 Dapatkan Data Eksternal <br><img loading=\"lazy\" decoding=\"async\" title=\"15-pulang-klik-data-eksternal\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/15-aller-a-la-maison-cliquer-sur-les-donnees-externes.png\" sizes=\"auto, \" srcset=\"\" alt=\"go-home-click-external-data\" width=\"564\" height=\"228\"><\/li><li> Di sini Anda akan menemukan beberapa opsi dan sumber yang tersedia untuk mengunduh data. Tapi kita perlu mendownload excel sederhana. Jadi ikuti langkah-langkah dan tangkapan layarnya dan klik \u201cDari sumber lain\u201d. <br><img loading=\"lazy\" decoding=\"async\" title=\"16-beberapa-pilihan-untuk-mengunggah-data\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/16-options-multiples-pour-telecharger-des-donnees.png\" sizes=\"auto, \" srcset=\"\" alt=\"multiple-options-to-upload-data\" width=\"576\" height=\"233\"><\/li><li> Sekarang Anda akan mendapatkan kotak dialog terbuka lagi. Gulir ke akhir untuk mendapatkan opsi file Excel dan klik Berikutnya. <br><img loading=\"lazy\" decoding=\"async\" title=\"17-dialog\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/17-boite-de-dialogue.png\" sizes=\"auto, \" srcset=\"\" alt=\"dialogue-box\" width=\"655\" height=\"528\"><\/li><li> Di sini Anda dapat mengganti nama koneksi dari nama default \u201cExcel\u201d. Klik Telusuri untuk memilih jalur ke file data Anda. <br><img loading=\"lazy\" decoding=\"async\" title=\"18-ganti nama-koneksi\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/18-renommer-la-connexion-2.png\" sizes=\"auto, \" srcset=\"\" alt=\"rename-the-connection\" width=\"649\" height=\"524\"><\/li><li> Selain itu, jika Anda ingin kolom teratas menjadi baris header, centang opsi \u201cGunakan baris pertama sebagai header kolom\u201d dan klik Berikutnya. <br><img loading=\"lazy\" decoding=\"async\" title=\"19 kolom-untuk-menjadi-header-baris\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/19-colonne-pour-etre-la-ligne-den-tete.png\" sizes=\"auto, \" srcset=\"\" alt=\"column-to-be-header-row\" width=\"625\" height=\"504\"><\/li><li> Pada akhirnya file diimpor ke model data dan klik selesai. <br><img loading=\"lazy\" decoding=\"async\" title=\"20-file-diimpor-dalam-data\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/20-fichier-importe-dans-les-donnees.png\" sizes=\"auto, \" srcset=\"\" alt=\"file-imported-to-the-data\" width=\"622\" height=\"502\"><\/li><li> Ini dia: berhasil dengan 28 baris yang diimpor. Sekarang serang dari dekat. <br><img loading=\"lazy\" decoding=\"async\" title=\"21 baris-diimpor-hit-close\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/21-lignes-importees-cloturees.png\" sizes=\"auto, \" srcset=\"\" alt=\"rows-imported-hit-close\" width=\"644\" height=\"519\"><\/li><li> Sekarang seperti inilah tampilannya. <br><img loading=\"lazy\" decoding=\"async\" title=\"Sepertinya 22 sampel\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/22-echantillon-ressemble.png\" sizes=\"auto, \" srcset=\"\" alt=\"sample-looks-like\" width=\"428\" height=\"468\"><\/li><li> Dari sini kita akan membuat tabel pivot dengan Beranda \u2192 Tabel Pivot <br><img loading=\"lazy\" decoding=\"async\" title=\"23-buat-papan-poros-per-rumah\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/23-creer-un-tableau-croise-dynamique-par-maison.png\" sizes=\"auto, \" srcset=\"\" alt=\"create-pivot-table-by-home\" width=\"692\" height=\"223\"><\/li><li> Karena kita memiliki data di Lembar 1, kita akan memperluas kolom dengan mengklik segitiga kecil di sebelahnya. <br><img loading=\"lazy\" decoding=\"async\" title=\"24-perluas-kolom\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/24-developper-les-colonnes-2.png\" sizes=\"auto, \" srcset=\"\" alt=\"expand-the-columns\" width=\"585\" height=\"371\"><\/li><li> Sekarang letakkan lokasi pada baris dan penyedia layanan pada nilai seperti yang kita lakukan sebelumnya. Ini akan menghasilkan tabel pivot sederhana dengan jumlah total penyedia layanan. <br><img loading=\"lazy\" decoding=\"async\" title=\"Lokasi-dari-25-tempat-di-baris\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Emplacement-de-25-places-sur-les-rangs.png\" sizes=\"auto, \" srcset=\"\" alt=\"place-location-on-the-rows\" width=\"194\" height=\"135\"><\/li><li> Inilah triknya. Sekarang buka jendela PowerPivot dan klik <strong>Measure<\/strong> untuk mendapatkan opsi <strong>Pengukuran Baru<\/strong> . <br><img loading=\"lazy\" decoding=\"async\" title=\"26 Jendela Power Pivot\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/26-vitres-a-pivot-electrique.png\" sizes=\"auto, \" srcset=\"\" alt=\"power-pivot-window\" width=\"556\" height=\"347\"><\/li><li> Sekarang tambahkan deskripsi nama yang diinginkan dan mulailah mengetik rumusnya di bagian rumus. <br><img loading=\"lazy\" decoding=\"async\" title=\"27-nama-dan-rumus yang diinginkan\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/27-nom-et-formule-souhaites.png\" sizes=\"auto, \" srcset=\"\" alt=\"desired-name-and-formula\" width=\"502\" height=\"364\"><\/li><li> Saat Anda mulai mengetik, Anda akan otomatis mendapatkan saran. Di sini kita memerlukan fungsi hitungan yang berbeda. Pilih fungsi penghitungan yang berbeda. <br><img loading=\"lazy\" decoding=\"async\" title=\"28-pilih-fungsi penghitungan-berbeda\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/28-selectionner-la-fonction-de-comptage-distinct.png\" sizes=\"auto, \" srcset=\"\" alt=\"select-distinct-count-function\" width=\"564\" height=\"410\"><\/li><li> Setelah itu tekan tombol tab atau mulai tanda kurung ( dan pilih kolom yang kita perlukan nomor pastinya. Seperti di sini kita memerlukan jumlah penyedia layanan yang berbeda. Oleh karena itu rumus kita akan terlihat seperti ini = DISTINCTCOUNT(Sheet1[Penyedia Layanan ]) ) <br><img loading=\"lazy\" decoding=\"async\" title=\"29-tekan-tombol-tab\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/29-appuyez-sur-le-bouton-de-tabulation.png\" sizes=\"auto, \" srcset=\"\" alt=\"press-the-tab-button\" width=\"567\" height=\"412\"><\/li><li> Pada akhirnya, pilih kategori. Karena kami mencari nomor unik penyedia layanan, kami akan memilih kategori \u201cNomor\u201d. <br><img loading=\"lazy\" decoding=\"async\" title=\"30-pilih-kategori\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/30-selectionner-la-categorie.png\" sizes=\"auto, \" srcset=\"\" alt=\"select-the-category\" width=\"497\" height=\"361\"><\/li><li> Ubah formatnya menjadi &#8220;Integer&#8221; dan tekan OK. Kolom lain akan ditambahkan ke tabel pivot yang akan memberi Anda entri unik. <br><img loading=\"lazy\" decoding=\"async\" title=\"31-ubah-format-menjadi-bilangan bulat\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/31-changer-le-format-en-nombre-entier.png\" sizes=\"auto, \" srcset=\"\" alt=\"change-format-to-whole-number\" width=\"263\" height=\"120\"><\/li><\/ol><div class=\"wp-block-group more-tutorials is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h2 class=\"wp-block-heading\"> Pelajari lebih lanjut tentang tabel pivot <\/h2><div class=\"wp-block-columns is-layout-flex wp-container-3\"><div class=\"wp-block-column is-layout-flow\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/id\/perhitungan-dalam-tabel-pivot\/\">Tambahkan bidang terhitung dan item (rumus dalam tabel pivot)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/kolom-peringkat\/\">Tambahkan baris dalam tabel pivot di Excel<\/a><\/li><\/ul><\/div><div class=\"wp-block-column is-layout-flow\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/id\/tanggal-grup\/\">Kelompokkan tanggal dalam tabel pivot<\/a><\/li><\/ul><\/div><\/div><p> \u21e0 Kembali ke <a href=\"https:\/\/exceladvisor.org\/id\/tabel-pivot\/\">Tutorial Tabel Pivot<\/a><\/p><\/div><\/div>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-1626","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Hitung nilai unik dalam tabel pivot<\/title>\n<meta name=\"description\" content=\"Dalam tutorial ini, Anda dapat mempelajari cara menghitung nilai unik dalam tabel pivot menggunakan metode yang berbeda.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/id\/menghitung-nilai-unik\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Hitung nilai unik dalam tabel pivot\" \/>\n<meta property=\"og:description\" content=\"Dalam tutorial ini, Anda dapat mempelajari cara menghitung nilai unik dalam tabel pivot menggunakan metode yang berbeda.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/menghitung-nilai-unik\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:20:17+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-aller-a-longlet-inserer.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data1\" content=\"4 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/id\/menghitung-nilai-unik\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/menghitung-nilai-unik\/\",\"name\":\"Hitung nilai unik dalam tabel pivot\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/menghitung-nilai-unik\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/menghitung-nilai-unik\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-aller-a-longlet-inserer.png\",\"datePublished\":\"2023-11-15T05:22:32+00:00\",\"dateModified\":\"2023-12-06T06:20:17+00:00\",\"description\":\"Dalam tutorial ini, Anda dapat mempelajari cara menghitung nilai unik dalam tabel pivot menggunakan metode yang berbeda.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/menghitung-nilai-unik\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/menghitung-nilai-unik\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/menghitung-nilai-unik\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-aller-a-longlet-inserer.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-aller-a-longlet-inserer.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/menghitung-nilai-unik\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Hitung nilai unik dalam tabel pivot\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"name\":\"Excel Advisor\",\"description\":\"Panduan utama Anda untuk mendominasi data!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/id\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"id\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Hitung nilai unik dalam tabel pivot","description":"Dalam tutorial ini, Anda dapat mempelajari cara menghitung nilai unik dalam tabel pivot menggunakan metode yang berbeda.","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:\/\/exceladvisor.org\/id\/menghitung-nilai-unik\/","og_locale":"id_ID","og_type":"article","og_title":"Hitung nilai unik dalam tabel pivot","og_description":"Dalam tutorial ini, Anda dapat mempelajari cara menghitung nilai unik dalam tabel pivot menggunakan metode yang berbeda.","og_url":"https:\/\/exceladvisor.org\/id\/menghitung-nilai-unik\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:20:17+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-aller-a-longlet-inserer.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Estimasi waktu membaca":"4 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/id\/menghitung-nilai-unik\/","url":"https:\/\/exceladvisor.org\/id\/menghitung-nilai-unik\/","name":"Hitung nilai unik dalam tabel pivot","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/menghitung-nilai-unik\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/menghitung-nilai-unik\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-aller-a-longlet-inserer.png","datePublished":"2023-11-15T05:22:32+00:00","dateModified":"2023-12-06T06:20:17+00:00","description":"Dalam tutorial ini, Anda dapat mempelajari cara menghitung nilai unik dalam tabel pivot menggunakan metode yang berbeda.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/menghitung-nilai-unik\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/menghitung-nilai-unik\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/menghitung-nilai-unik\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-aller-a-longlet-inserer.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-aller-a-longlet-inserer.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/menghitung-nilai-unik\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Hitung nilai unik dalam tabel pivot"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/id\/#website","url":"https:\/\/exceladvisor.org\/id\/","name":"Excel Advisor","description":"Panduan utama Anda untuk mendominasi data!","publisher":{"@id":"https:\/\/exceladvisor.org\/id\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/id\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"id"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/id\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/id\/","logo":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1626","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/comments?post=1626"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1626\/revisions"}],"predecessor-version":[{"id":2909,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1626\/revisions\/2909"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1626"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}