Dear Pak DD Terima kasih atas bantuannya tetapi sebelumnya ada data yang tidak terinput tidak saya cantumkan pada file.File saya lampiorkan kembali sebagai contoh kasus.Mohon bantuannya kembali untuk memberikan solusi untuk pengaturan field nya. terima kasih
Pada Jumat, 30 Oktober 2015 15:28, "'Dede Sulaeman' pmaho_l...@pinusmerahabadi.co.id [belajar-excel]" <belajar-excel@yahoogroups.com> menulis: Dear Mr Rudi, See Attach, semoga sesuai harapan. Salam, DD From: belajar-excel@yahoogroups.com[mailto:belajar-excel@yahoogroups.com] Sent: 30 Oktober 2015 13:16 To: belajar-excel@yahoogroups.com Subject: [belajar-excel] Menampilkan subtotal dan grand total qty.produk pada pivot table [1 Attachment] Dear Be Exceller Selamat siang Mohon kiranya dapat membantuuntuk memberikan pencerahan pada permasalahan pengolahan data yang saya hadapi. Disini saya ingin membuatpivot table dari sheet!DATA dengan menampilkan total qty per product dan jugaingin menampilkan grand Total qty berdsarkan Tanggal. Contoh bentuk pivot table nyasaya lampirkan pada file. Besar harapan saya paramaster dapat memberikan pencerahannya, sebelumnya Saya ucapkan terima kasih. Salam Ruddi #yiv7666274189 #yiv7666274189 -- #yiv7666274189ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7666274189 #yiv7666274189ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7666274189 #yiv7666274189ygrp-mkp #yiv7666274189hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv7666274189 #yiv7666274189ygrp-mkp #yiv7666274189ads {margin-bottom:10px;}#yiv7666274189 #yiv7666274189ygrp-mkp .yiv7666274189ad {padding:0 0;}#yiv7666274189 #yiv7666274189ygrp-mkp .yiv7666274189ad p {margin:0;}#yiv7666274189 #yiv7666274189ygrp-mkp .yiv7666274189ad a {color:#0000ff;text-decoration:none;}#yiv7666274189 #yiv7666274189ygrp-sponsor #yiv7666274189ygrp-lc {font-family:Arial;}#yiv7666274189 #yiv7666274189ygrp-sponsor #yiv7666274189ygrp-lc #yiv7666274189hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7666274189 #yiv7666274189ygrp-sponsor #yiv7666274189ygrp-lc .yiv7666274189ad {margin-bottom:10px;padding:0 0;}#yiv7666274189 #yiv7666274189actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7666274189 #yiv7666274189activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7666274189 #yiv7666274189activity span {font-weight:700;}#yiv7666274189 #yiv7666274189activity span:first-child {text-transform:uppercase;}#yiv7666274189 #yiv7666274189activity span a {color:#5085b6;text-decoration:none;}#yiv7666274189 #yiv7666274189activity span span {color:#ff7900;}#yiv7666274189 #yiv7666274189activity span .yiv7666274189underline {text-decoration:underline;}#yiv7666274189 .yiv7666274189attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv7666274189 .yiv7666274189attach div a {text-decoration:none;}#yiv7666274189 .yiv7666274189attach img {border:none;padding-right:5px;}#yiv7666274189 .yiv7666274189attach label {display:block;margin-bottom:5px;}#yiv7666274189 .yiv7666274189attach label a {text-decoration:none;}#yiv7666274189 blockquote {margin:0 0 0 4px;}#yiv7666274189 .yiv7666274189bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv7666274189 .yiv7666274189bold a {text-decoration:none;}#yiv7666274189 dd.yiv7666274189last p a {font-family:Verdana;font-weight:700;}#yiv7666274189 dd.yiv7666274189last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7666274189 dd.yiv7666274189last p span.yiv7666274189yshortcuts {margin-right:0;}#yiv7666274189 div.yiv7666274189attach-table div div a {text-decoration:none;}#yiv7666274189 div.yiv7666274189attach-table {width:400px;}#yiv7666274189 div.yiv7666274189file-title a, #yiv7666274189 div.yiv7666274189file-title a:active, #yiv7666274189 div.yiv7666274189file-title a:hover, #yiv7666274189 div.yiv7666274189file-title a:visited {text-decoration:none;}#yiv7666274189 div.yiv7666274189photo-title a, #yiv7666274189 div.yiv7666274189photo-title a:active, #yiv7666274189 div.yiv7666274189photo-title a:hover, #yiv7666274189 div.yiv7666274189photo-title a:visited {text-decoration:none;}#yiv7666274189 div#yiv7666274189ygrp-mlmsg #yiv7666274189ygrp-msg p a span.yiv7666274189yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7666274189 .yiv7666274189green {color:#628c2a;}#yiv7666274189 .yiv7666274189MsoNormal {margin:0 0 0 0;}#yiv7666274189 o {font-size:0;}#yiv7666274189 #yiv7666274189photos div {float:left;width:72px;}#yiv7666274189 #yiv7666274189photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv7666274189 #yiv7666274189photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7666274189 #yiv7666274189reco-category {font-size:77%;}#yiv7666274189 #yiv7666274189reco-desc {font-size:77%;}#yiv7666274189 .yiv7666274189replbq {margin:4px;}#yiv7666274189 #yiv7666274189ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv7666274189 #yiv7666274189ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv7666274189 #yiv7666274189ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv7666274189 #yiv7666274189ygrp-mlmsg select, #yiv7666274189 input, #yiv7666274189 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv7666274189 #yiv7666274189ygrp-mlmsg pre, #yiv7666274189 code {font:115% monospace;}#yiv7666274189 #yiv7666274189ygrp-mlmsg * {line-height:1.22em;}#yiv7666274189 #yiv7666274189ygrp-mlmsg #yiv7666274189logo {padding-bottom:10px;}#yiv7666274189 #yiv7666274189ygrp-msg p a {font-family:Verdana;}#yiv7666274189 #yiv7666274189ygrp-msg p#yiv7666274189attach-count span {color:#1E66AE;font-weight:700;}#yiv7666274189 #yiv7666274189ygrp-reco #yiv7666274189reco-head {color:#ff7900;font-weight:700;}#yiv7666274189 #yiv7666274189ygrp-reco {margin-bottom:20px;padding:0px;}#yiv7666274189 #yiv7666274189ygrp-sponsor #yiv7666274189ov li a {font-size:130%;text-decoration:none;}#yiv7666274189 #yiv7666274189ygrp-sponsor #yiv7666274189ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv7666274189 #yiv7666274189ygrp-sponsor #yiv7666274189ov ul {margin:0;padding:0 0 0 8px;}#yiv7666274189 #yiv7666274189ygrp-text {font-family:Georgia;}#yiv7666274189 #yiv7666274189ygrp-text p {margin:0 0 1em 0;}#yiv7666274189 #yiv7666274189ygrp-text tt {font-size:120%;}#yiv7666274189 #yiv7666274189ygrp-vital ul li:last-child {border-right:none !important;}#yiv7666274189
Book1.xlsx
Description: MS-Excel 2007 spreadsheet