dear all,
saya ingin menanyakan untuk lampiran file yang dari bos kid shet mydata, ada
yang saya bingung neh, 1. ada filds yang namanya SAK, tapi di source datanya
tidak ada yang header SAK...tu buat or cara mengadakannya gmn ya...?2. dalam
pivot yang bos kid buat ada header namanya saldo akhir, itu maksudnya gmn ya,
cara buatnya...?
tolong di bantu untuk menjelaskannya trimakasih. br,
odong nando
Pada Selasa, 22 Desember 2015 20:02, "'Mr. Kid' [email protected]
[belajar-excel]" <[email protected]> menulis:
Hai Nando,
Untuk kasus Anda,
Pivot consolidation kurang fleksibel.
Excel Pivot Table masih cukup fleksibel walau banyak batasannya.
File terlampir.
Wassalam,
Kid
2015-12-21 14:57 GMT+07:00 odong nando [email protected] [belajar-excel]
<[email protected]>:
dear all,
saya sedang membuat report dengan menggunakan 2 sheet sebagai data, hasil yang
di inginkan seperti membuat pivot saja, namun ada beberapa tambahan sedikit
yang membuat bingun saya sendiri, saya sudah menggunakan pivot wizart namun
masih bingung untuk mendapat hasil yang diinginkan.
untuk lebih jelas bisa dilihat dari lampiran berikut. br,
odong nando
#yiv4256253419 #yiv4256253419 -- #yiv4256253419ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv4256253419
#yiv4256253419ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv4256253419
#yiv4256253419ygrp-mkp #yiv4256253419hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv4256253419 #yiv4256253419ygrp-mkp #yiv4256253419ads
{margin-bottom:10px;}#yiv4256253419 #yiv4256253419ygrp-mkp .yiv4256253419ad
{padding:0 0;}#yiv4256253419 #yiv4256253419ygrp-mkp .yiv4256253419ad p
{margin:0;}#yiv4256253419 #yiv4256253419ygrp-mkp .yiv4256253419ad a
{color:#0000ff;text-decoration:none;}#yiv4256253419 #yiv4256253419ygrp-sponsor
#yiv4256253419ygrp-lc {font-family:Arial;}#yiv4256253419
#yiv4256253419ygrp-sponsor #yiv4256253419ygrp-lc #yiv4256253419hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv4256253419
#yiv4256253419ygrp-sponsor #yiv4256253419ygrp-lc .yiv4256253419ad
{margin-bottom:10px;padding:0 0;}#yiv4256253419 #yiv4256253419actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv4256253419
#yiv4256253419activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv4256253419
#yiv4256253419activity span {font-weight:700;}#yiv4256253419
#yiv4256253419activity span:first-child
{text-transform:uppercase;}#yiv4256253419 #yiv4256253419activity span a
{color:#5085b6;text-decoration:none;}#yiv4256253419 #yiv4256253419activity span
span {color:#ff7900;}#yiv4256253419 #yiv4256253419activity span
.yiv4256253419underline {text-decoration:underline;}#yiv4256253419
.yiv4256253419attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv4256253419 .yiv4256253419attach div a
{text-decoration:none;}#yiv4256253419 .yiv4256253419attach img
{border:none;padding-right:5px;}#yiv4256253419 .yiv4256253419attach label
{display:block;margin-bottom:5px;}#yiv4256253419 .yiv4256253419attach label a
{text-decoration:none;}#yiv4256253419 blockquote {margin:0 0 0
4px;}#yiv4256253419 .yiv4256253419bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv4256253419
.yiv4256253419bold a {text-decoration:none;}#yiv4256253419 dd.yiv4256253419last
p a {font-family:Verdana;font-weight:700;}#yiv4256253419 dd.yiv4256253419last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv4256253419
dd.yiv4256253419last p span.yiv4256253419yshortcuts
{margin-right:0;}#yiv4256253419 div.yiv4256253419attach-table div div a
{text-decoration:none;}#yiv4256253419 div.yiv4256253419attach-table
{width:400px;}#yiv4256253419 div.yiv4256253419file-title a, #yiv4256253419
div.yiv4256253419file-title a:active, #yiv4256253419
div.yiv4256253419file-title a:hover, #yiv4256253419 div.yiv4256253419file-title
a:visited {text-decoration:none;}#yiv4256253419 div.yiv4256253419photo-title a,
#yiv4256253419 div.yiv4256253419photo-title a:active, #yiv4256253419
div.yiv4256253419photo-title a:hover, #yiv4256253419
div.yiv4256253419photo-title a:visited {text-decoration:none;}#yiv4256253419
div#yiv4256253419ygrp-mlmsg #yiv4256253419ygrp-msg p a
span.yiv4256253419yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv4256253419
.yiv4256253419green {color:#628c2a;}#yiv4256253419 .yiv4256253419MsoNormal
{margin:0 0 0 0;}#yiv4256253419 o {font-size:0;}#yiv4256253419
#yiv4256253419photos div {float:left;width:72px;}#yiv4256253419
#yiv4256253419photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv4256253419
#yiv4256253419photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv4256253419
#yiv4256253419reco-category {font-size:77%;}#yiv4256253419
#yiv4256253419reco-desc {font-size:77%;}#yiv4256253419 .yiv4256253419replbq
{margin:4px;}#yiv4256253419 #yiv4256253419ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv4256253419 #yiv4256253419ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv4256253419
#yiv4256253419ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv4256253419
#yiv4256253419ygrp-mlmsg select, #yiv4256253419 input, #yiv4256253419 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv4256253419
#yiv4256253419ygrp-mlmsg pre, #yiv4256253419 code {font:115%
monospace;}#yiv4256253419 #yiv4256253419ygrp-mlmsg *
{line-height:1.22em;}#yiv4256253419 #yiv4256253419ygrp-mlmsg #yiv4256253419logo
{padding-bottom:10px;}#yiv4256253419 #yiv4256253419ygrp-msg p a
{font-family:Verdana;}#yiv4256253419 #yiv4256253419ygrp-msg
p#yiv4256253419attach-count span {color:#1E66AE;font-weight:700;}#yiv4256253419
#yiv4256253419ygrp-reco #yiv4256253419reco-head
{color:#ff7900;font-weight:700;}#yiv4256253419 #yiv4256253419ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv4256253419 #yiv4256253419ygrp-sponsor
#yiv4256253419ov li a {font-size:130%;text-decoration:none;}#yiv4256253419
#yiv4256253419ygrp-sponsor #yiv4256253419ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv4256253419
#yiv4256253419ygrp-sponsor #yiv4256253419ov ul {margin:0;padding:0 0 0
8px;}#yiv4256253419 #yiv4256253419ygrp-text
{font-family:Georgia;}#yiv4256253419 #yiv4256253419ygrp-text p {margin:0 0 1em
0;}#yiv4256253419 #yiv4256253419ygrp-text tt {font-size:120%;}#yiv4256253419
#yiv4256253419ygrp-vital ul li:last-child {border-right:none
!important;}#yiv4256253419
