Jangan lupa pada Tab "Totals & Filters" PivotTable Optionsnya diset "Allow multiple filters per field" (centang kotak kosong disampingnya). Salam,HK
Sent from Yahoo Mail on Android On Mon, Apr 20, 2020 at 14:03, ivan budiman [email protected] [belajar-excel]<[email protected]> wrote: Hi Pak HK, Wah thanks yaaa udah dikasih step2nya.. Very helpful :) Regards, M I B - thankfulness - On Monday, 20 April 2020, 01:57:22 pm GMT+7, hendrik karnadi [email protected] [belajar-excel] <[email protected]> wrote: Hai Ivan, Coba 3 langkah terlampir:Langkah 1 untuk membuat Pivot di Sheet BaruLangkah 2 untuk membuat "struktur" atau isi PivotnyaLangkah 3 untuk memfilter Row Labelsnya (Family). Semoga cukup jelas. Salam,HK Pada Senin, 20 April 2020 13.32.50 GMT+7, ivan budiman [email protected] [belajar-excel] <[email protected]> menulis: Halo Pak Bagus, Thank you untuk solusinya Pak. Jadi pakai pivot ya, bagaimana caranya menampilkan top 5 nya di setiap family Pak? Thank you Regards, M I B - thankfulness - On Monday, 20 April 2020, 12:53:29 pm GMT+7, Bagus [email protected] [belajar-excel] <[email protected]> wrote: Dear pak Ivan; coba pake pivot tabel. file terlampir Wassalam Bagus Pada tanggal Sen, 20 Apr 2020 pukul 10.29 ivan budiman [email protected] [belajar-excel] <[email protected]> menulis: Dear Para Suhu Be Excel, Semoga semua anggota group dalam keadaan sehat. Mohon bantuannya, saya punya case ingin mengambil item dengan top 5 sales di setiap family-nya. Sehingga nanti output yang ingin ditampilkan sbb Family_11. Item_rank_12. Item_rank_23. Item_rank_34. Item_rank_45. Item_rank_5 Family_21. Item_rank_12. Item_rank_23. Item_rank_34. Item_rank_45. Item_rank_5 dst Masalahnya, ada 1200 family dengan masing-masing family ada ratusan bahkan ribuan item. Mohon dibantu formula cepat nya seperti apa ya? Terlampir ilustrasi datanya Thank you atas bantuan para suhu Regards, M I B - thankfulness - #yiv9206301446 #yiv9206301446 -- #yiv9206301446ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv9206301446 #yiv9206301446ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv9206301446 #yiv9206301446ygrp-mkp #yiv9206301446hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv9206301446 #yiv9206301446ygrp-mkp #yiv9206301446ads {margin-bottom:10px;}#yiv9206301446 #yiv9206301446ygrp-mkp .yiv9206301446ad {padding:0 0;}#yiv9206301446 #yiv9206301446ygrp-mkp .yiv9206301446ad p {margin:0;}#yiv9206301446 #yiv9206301446ygrp-mkp .yiv9206301446ad a {color:#0000ff;text-decoration:none;}#yiv9206301446 #yiv9206301446ygrp-sponsor #yiv9206301446ygrp-lc {font-family:Arial;}#yiv9206301446 #yiv9206301446ygrp-sponsor #yiv9206301446ygrp-lc #yiv9206301446hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv9206301446 #yiv9206301446ygrp-sponsor #yiv9206301446ygrp-lc .yiv9206301446ad {margin-bottom:10px;padding:0 0;}#yiv9206301446 #yiv9206301446actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv9206301446 #yiv9206301446activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv9206301446 #yiv9206301446activity span {font-weight:700;}#yiv9206301446 #yiv9206301446activity span:first-child {text-transform:uppercase;}#yiv9206301446 #yiv9206301446activity span a {color:#5085b6;text-decoration:none;}#yiv9206301446 #yiv9206301446activity span span {color:#ff7900;}#yiv9206301446 #yiv9206301446activity span .yiv9206301446underline {text-decoration:underline;}#yiv9206301446 .yiv9206301446attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv9206301446 .yiv9206301446attach div a {text-decoration:none;}#yiv9206301446 .yiv9206301446attach img {border:none;padding-right:5px;}#yiv9206301446 .yiv9206301446attach label {display:block;margin-bottom:5px;}#yiv9206301446 .yiv9206301446attach label a {text-decoration:none;}#yiv9206301446 blockquote {margin:0 0 0 4px;}#yiv9206301446 .yiv9206301446bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv9206301446 .yiv9206301446bold a {text-decoration:none;}#yiv9206301446 dd.yiv9206301446last p a {font-family:Verdana;font-weight:700;}#yiv9206301446 dd.yiv9206301446last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv9206301446 dd.yiv9206301446last p span.yiv9206301446yshortcuts {margin-right:0;}#yiv9206301446 div.yiv9206301446attach-table div div a {text-decoration:none;}#yiv9206301446 div.yiv9206301446attach-table {width:400px;}#yiv9206301446 div.yiv9206301446file-title a, #yiv9206301446 div.yiv9206301446file-title a:active, #yiv9206301446 div..yiv9206301446file-title a:hover, #yiv9206301446 div.yiv9206301446file-title a:visited {text-decoration:none;}#yiv9206301446 div.yiv9206301446photo-title a, #yiv9206301446 div.yiv9206301446photo-title a:active, #yiv9206301446 div.yiv9206301446photo-title a:hover, #yiv9206301446 div.yiv9206301446photo-title a:visited {text-decoration:none;}#yiv9206301446 div#yiv9206301446ygrp-mlmsg #yiv9206301446ygrp-msg p a span.yiv9206301446yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv9206301446 .yiv9206301446green {color:#628c2a;}#yiv9206301446 .yiv9206301446MsoNormal {margin:0 0 0 0;}#yiv9206301446 o {font-size:0;}#yiv9206301446 #yiv9206301446photos div {float:left;width:72px;}#yiv9206301446 #yiv9206301446photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv9206301446 #yiv9206301446photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv9206301446 #yiv9206301446reco-category {font-size:77%;}#yiv9206301446 #yiv9206301446reco-desc {font-size:77%;}#yiv9206301446 .yiv9206301446replbq {margin:4px;}#yiv9206301446 #yiv9206301446ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv9206301446 #yiv9206301446ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv9206301446 #yiv9206301446ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv9206301446 #yiv9206301446ygrp-mlmsg select, #yiv9206301446 input, #yiv9206301446 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv9206301446 #yiv9206301446ygrp-mlmsg pre, #yiv9206301446 code {font:115% monospace;}#yiv9206301446 #yiv9206301446ygrp-mlmsg * {line-height:1.22em;}#yiv9206301446 #yiv9206301446ygrp-mlmsg #yiv9206301446logo {padding-bottom:10px;}#yiv9206301446 #yiv9206301446ygrp-msg p a {font-family:Verdana;}#yiv9206301446 #yiv9206301446ygrp-msg p#yiv9206301446attach-count span {color:#1E66AE;font-weight:700;}#yiv9206301446 #yiv9206301446ygrp-reco #yiv9206301446reco-head {color:#ff7900;font-weight:700;}#yiv9206301446 #yiv9206301446ygrp-reco {margin-bottom:20px;padding:0px;}#yiv9206301446 #yiv9206301446ygrp-sponsor #yiv9206301446ov li a {font-size:130%;text-decoration:none;}#yiv9206301446 #yiv9206301446ygrp-sponsor #yiv9206301446ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv9206301446 #yiv9206301446ygrp-sponsor #yiv9206301446ov ul {margin:0;padding:0 0 0 8px;}#yiv9206301446 #yiv9206301446ygrp-text {font-family:Georgia;}#yiv9206301446 #yiv9206301446ygrp-text p {margin:0 0 1em 0;}#yiv9206301446 #yiv9206301446ygrp-text tt {font-size:120%;}#yiv9206301446 #yiv9206301446ygrp-vital ul li:last-child {border-right:none !important;}#yiv9206301446
