Apakah pivot table tidak bisa melakukan summary yang dimaksud ? Bisa jadi dengan data source yang baik, susunan seperti di sheet1 dan sheet2 bisa didapatkan dengan sebuah pivot table saja.
Wassalam, Kid. On Fri, Feb 6, 2015 at 7:19 PM, James Bond [email protected] [belajar-excel] <[email protected]> wrote: > > > Isengnya aja keren Om Agus... hehehehe, terima kasih atas pencerahan dan > waktu luangnya... > > Salam, > > James > > -------------------------------------------- > On Fri, 6/2/15, Nang Agus [email protected] [belajar-excel] < > [email protected]> wrote: > > Subject: Re: [belajar-excel] Memfilter data pada kolom dan mensummarykan > nilai-nya [1 Attachment] > To: "BExcel" <[email protected]> > Date: Friday, 6 February, 2015, 12:14 PM > > > > > > > > > > > > > maaf sekedar iseng > > 2015-02-05 4:01 GMT+07:00 > James Bond [email protected] > [belajar-excel] <[email protected]>: > > > > > > > > > > > > > > > > > > > > > > Dear Be Exceller, > > Selamat pagi, mohon bantuan pencerahannya... > > > > Seperti terlampir saya masih bingung bagaimana memfilter > kolom E dan kemudian hasil filter tsb di total lagi cost-nya > > dengan melihat kembali kolom D.. Pada lampiran telah saya > isi manual kolom E & F bagaimana hasil yang > diharapkan. > > > > Terima kasih. > > Salam, > > > James > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > #yiv7419401426 #yiv7419401426 -- > #yiv7419401426ygrp-mkp { > border:1px solid #d8d8d8;font-family:Arial;margin:10px > 0;padding:0 10px;} > > #yiv7419401426 #yiv7419401426ygrp-mkp hr { > border:1px solid #d8d8d8;} > > #yiv7419401426 #yiv7419401426ygrp-mkp #yiv7419401426hd { > color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px > 0;} > > #yiv7419401426 #yiv7419401426ygrp-mkp #yiv7419401426ads { > margin-bottom:10px;} > > #yiv7419401426 #yiv7419401426ygrp-mkp .yiv7419401426ad { > padding:0 0;} > > #yiv7419401426 #yiv7419401426ygrp-mkp .yiv7419401426ad p { > margin:0;} > > #yiv7419401426 #yiv7419401426ygrp-mkp .yiv7419401426ad a { > color:#0000ff;text-decoration:none;} > #yiv7419401426 #yiv7419401426ygrp-sponsor > #yiv7419401426ygrp-lc { > font-family:Arial;} > > #yiv7419401426 #yiv7419401426ygrp-sponsor > #yiv7419401426ygrp-lc #yiv7419401426hd { > margin:10px > 0px;font-weight:700;font-size:78%;line-height:122%;} > > #yiv7419401426 #yiv7419401426ygrp-sponsor > #yiv7419401426ygrp-lc .yiv7419401426ad { > margin-bottom:10px;padding:0 0;} > > #yiv7419401426 #yiv7419401426actions { > font-family:Verdana;font-size:11px;padding:10px 0;} > > #yiv7419401426 #yiv7419401426activity { > > background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;} > > #yiv7419401426 #yiv7419401426activity span { > font-weight:700;} > > #yiv7419401426 #yiv7419401426activity span:first-child { > text-transform:uppercase;} > > #yiv7419401426 #yiv7419401426activity span a { > color:#5085b6;text-decoration:none;} > > #yiv7419401426 #yiv7419401426activity span span { > color:#ff7900;} > > #yiv7419401426 #yiv7419401426activity span > .yiv7419401426underline { > text-decoration:underline;} > > #yiv7419401426 .yiv7419401426attach { > clear:both;display:table;font-family:Arial;font-size:12px;padding:10px > 0;width:400px;} > > #yiv7419401426 .yiv7419401426attach div a { > text-decoration:none;} > > #yiv7419401426 .yiv7419401426attach img { > border:none;padding-right:5px;} > > #yiv7419401426 .yiv7419401426attach label { > display:block;margin-bottom:5px;} > > #yiv7419401426 .yiv7419401426attach label a { > text-decoration:none;} > > #yiv7419401426 blockquote { > margin:0 0 0 4px;} > > #yiv7419401426 .yiv7419401426bold { > font-family:Arial;font-size:13px;font-weight:700;} > > #yiv7419401426 .yiv7419401426bold a { > text-decoration:none;} > > #yiv7419401426 dd.yiv7419401426last p a { > font-family:Verdana;font-weight:700;} > > #yiv7419401426 dd.yiv7419401426last p span { > margin-right:10px;font-family:Verdana;font-weight:700;} > > #yiv7419401426 dd.yiv7419401426last p > span.yiv7419401426yshortcuts { > margin-right:0;} > > #yiv7419401426 div.yiv7419401426attach-table div div a { > text-decoration:none;} > > #yiv7419401426 div.yiv7419401426attach-table { > width:400px;} > > #yiv7419401426 div.yiv7419401426file-title a, #yiv7419401426 > div.yiv7419401426file-title a:active, #yiv7419401426 > div.yiv7419401426file-title a:hover, #yiv7419401426 > div.yiv7419401426file-title a:visited { > text-decoration:none;} > > #yiv7419401426 div.yiv7419401426photo-title a, > #yiv7419401426 div.yiv7419401426photo-title a:active, > #yiv7419401426 div.yiv7419401426photo-title a:hover, > #yiv7419401426 div.yiv7419401426photo-title a:visited { > text-decoration:none;} > > #yiv7419401426 div#yiv7419401426ygrp-mlmsg > #yiv7419401426ygrp-msg p a span.yiv7419401426yshortcuts { > font-family:Verdana;font-size:10px;font-weight:normal;} > > #yiv7419401426 .yiv7419401426green { > color:#628c2a;} > > #yiv7419401426 .yiv7419401426MsoNormal { > margin:0 0 0 0;} > > #yiv7419401426 o { > font-size:0;} > > #yiv7419401426 #yiv7419401426photos div { > float:left;width:72px;} > > #yiv7419401426 #yiv7419401426photos div div { > border:1px solid > #666666;height:62px;overflow:hidden;width:62px;} > > #yiv7419401426 #yiv7419401426photos div label { > > color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;} > > #yiv7419401426 #yiv7419401426reco-category { > font-size:77%;} > > #yiv7419401426 #yiv7419401426reco-desc { > font-size:77%;} > > #yiv7419401426 .yiv7419401426replbq { > margin:4px;} > > #yiv7419401426 #yiv7419401426ygrp-actbar div a:first-child { > margin-right:2px;padding-right:5px;} > > #yiv7419401426 #yiv7419401426ygrp-mlmsg { > font-size:13px;font-family:Arial, helvetica, clean, > sans-serif;} > > #yiv7419401426 #yiv7419401426ygrp-mlmsg table { > font-size:inherit;font:100%;} > > #yiv7419401426 #yiv7419401426ygrp-mlmsg select, > #yiv7419401426 input, #yiv7419401426 textarea { > font:99% Arial, Helvetica, clean, sans-serif;} > > #yiv7419401426 #yiv7419401426ygrp-mlmsg pre, #yiv7419401426 > code { > font:115% monospace;} > > #yiv7419401426 #yiv7419401426ygrp-mlmsg * { > line-height:1.22em;} > > #yiv7419401426 #yiv7419401426ygrp-mlmsg #yiv7419401426logo { > padding-bottom:10px;} > > > #yiv7419401426 #yiv7419401426ygrp-msg p a { > font-family:Verdana;} > > #yiv7419401426 #yiv7419401426ygrp-msg > p#yiv7419401426attach-count span { > color:#1E66AE;font-weight:700;} > > #yiv7419401426 #yiv7419401426ygrp-reco > #yiv7419401426reco-head { > color:#ff7900;font-weight:700;} > > #yiv7419401426 #yiv7419401426ygrp-reco { > margin-bottom:20px;padding:0px;} > > #yiv7419401426 #yiv7419401426ygrp-sponsor #yiv7419401426ov > li a { > font-size:130%;text-decoration:none;} > > #yiv7419401426 #yiv7419401426ygrp-sponsor #yiv7419401426ov > li { > font-size:77%;list-style-type:square;padding:6px 0;} > > #yiv7419401426 #yiv7419401426ygrp-sponsor #yiv7419401426ov > ul { > margin:0;padding:0 0 0 8px;} > > #yiv7419401426 #yiv7419401426ygrp-text { > font-family:Georgia;} > > #yiv7419401426 #yiv7419401426ygrp-text p { > margin:0 0 1em 0;} > > #yiv7419401426 #yiv7419401426ygrp-text tt { > font-size:120%;} > > #yiv7419401426 #yiv7419401426ygrp-vital ul li:last-child { > border-right:none !important; > } > #yiv7419401426 > > >
