Mantap para suhu semua, terima kasih atas pencerahannya.
Pada Sabtu, 18 Januari 2020 20.06.54 WIB, 'Mr. Kid' [email protected]
[XL-mania] <[email protected]> menulis:
menampilkan selisih nilai antar kolom dalam pivot table :1. pasang kolom nilai
ke bagian values2. klik kanan sebuah nilai dalam pivot table -> pilih value
field settings 3. -> klik tab show values as -> bagian show values as : pilih
difference from -> base field : pilih field periode -> base item : pilih
previous -> ok sampai kembali ke pivot table
On Mon, Jan 13, 2020 at 2:36 PM TJ [email protected] [XL-mania]
<[email protected]> wrote:
Dear para suhu,
Saya mau bertanya, bagaimana caranya untuk menambahkan kolom dalam pivot table,
di mana kolom tersebut adalah operasi dari kolom2 sebelumnya.Misalkan pada
contoh file yg saya kirimkan, saya ingin menambahkan kolom baru berupa operasi
selisih angka antara periode berjalan dengan periode sebelumnya.Mohon petunjuk
para suhu sekalian.
Terimakasih...
#yiv4325107315 #yiv4325107315 -- #yiv4325107315ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv4325107315
#yiv4325107315ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv4325107315
#yiv4325107315ygrp-mkp #yiv4325107315hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv4325107315 #yiv4325107315ygrp-mkp #yiv4325107315ads
{margin-bottom:10px;}#yiv4325107315 #yiv4325107315ygrp-mkp .yiv4325107315ad
{padding:0 0;}#yiv4325107315 #yiv4325107315ygrp-mkp .yiv4325107315ad p
{margin:0;}#yiv4325107315 #yiv4325107315ygrp-mkp .yiv4325107315ad a
{color:#0000ff;text-decoration:none;}#yiv4325107315 #yiv4325107315ygrp-sponsor
#yiv4325107315ygrp-lc {font-family:Arial;}#yiv4325107315
#yiv4325107315ygrp-sponsor #yiv4325107315ygrp-lc #yiv4325107315hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv4325107315
#yiv4325107315ygrp-sponsor #yiv4325107315ygrp-lc .yiv4325107315ad
{margin-bottom:10px;padding:0 0;}#yiv4325107315 #yiv4325107315actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv4325107315
#yiv4325107315activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv4325107315
#yiv4325107315activity span {font-weight:700;}#yiv4325107315
#yiv4325107315activity span:first-child
{text-transform:uppercase;}#yiv4325107315 #yiv4325107315activity span a
{color:#5085b6;text-decoration:none;}#yiv4325107315 #yiv4325107315activity span
span {color:#ff7900;}#yiv4325107315 #yiv4325107315activity span
.yiv4325107315underline {text-decoration:underline;}#yiv4325107315
.yiv4325107315attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv4325107315 .yiv4325107315attach div a
{text-decoration:none;}#yiv4325107315 .yiv4325107315attach img
{border:none;padding-right:5px;}#yiv4325107315 .yiv4325107315attach label
{display:block;margin-bottom:5px;}#yiv4325107315 .yiv4325107315attach label a
{text-decoration:none;}#yiv4325107315 blockquote {margin:0 0 0
4px;}#yiv4325107315 .yiv4325107315bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv4325107315
.yiv4325107315bold a {text-decoration:none;}#yiv4325107315 dd.yiv4325107315last
p a {font-family:Verdana;font-weight:700;}#yiv4325107315 dd.yiv4325107315last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv4325107315
dd.yiv4325107315last p span.yiv4325107315yshortcuts
{margin-right:0;}#yiv4325107315 div.yiv4325107315attach-table div div a
{text-decoration:none;}#yiv4325107315 div.yiv4325107315attach-table
{width:400px;}#yiv4325107315 div.yiv4325107315file-title a, #yiv4325107315
div.yiv4325107315file-title a:active, #yiv4325107315
div.yiv4325107315file-title a:hover, #yiv4325107315 div.yiv4325107315file-title
a:visited {text-decoration:none;}#yiv4325107315 div.yiv4325107315photo-title a,
#yiv4325107315 div.yiv4325107315photo-title a:active, #yiv4325107315
div.yiv4325107315photo-title a:hover, #yiv4325107315
div.yiv4325107315photo-title a:visited {text-decoration:none;}#yiv4325107315
div#yiv4325107315ygrp-mlmsg #yiv4325107315ygrp-msg p a
span.yiv4325107315yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv4325107315
.yiv4325107315green {color:#628c2a;}#yiv4325107315 .yiv4325107315MsoNormal
{margin:0 0 0 0;}#yiv4325107315 o {font-size:0;}#yiv4325107315
#yiv4325107315photos div {float:left;width:72px;}#yiv4325107315
#yiv4325107315photos div div {border:1px solid
#666666;min-height:62px;overflow:hidden;width:62px;}#yiv4325107315
#yiv4325107315photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv4325107315
#yiv4325107315reco-category {font-size:77%;}#yiv4325107315
#yiv4325107315reco-desc {font-size:77%;}#yiv4325107315 .yiv4325107315replbq
{margin:4px;}#yiv4325107315 #yiv4325107315ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv4325107315 #yiv4325107315ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv4325107315
#yiv4325107315ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv4325107315
#yiv4325107315ygrp-mlmsg select, #yiv4325107315 input, #yiv4325107315 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv4325107315
#yiv4325107315ygrp-mlmsg pre, #yiv4325107315 code {font:115%
monospace;}#yiv4325107315 #yiv4325107315ygrp-mlmsg *
{line-height:1.22em;}#yiv4325107315 #yiv4325107315ygrp-mlmsg #yiv4325107315logo
{padding-bottom:10px;}#yiv4325107315 #yiv4325107315ygrp-msg p a
{font-family:Verdana;}#yiv4325107315 #yiv4325107315ygrp-msg
p#yiv4325107315attach-count span {color:#1E66AE;font-weight:700;}#yiv4325107315
#yiv4325107315ygrp-reco #yiv4325107315reco-head
{color:#ff7900;font-weight:700;}#yiv4325107315 #yiv4325107315ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv4325107315 #yiv4325107315ygrp-sponsor
#yiv4325107315ov li a {font-size:130%;text-decoration:none;}#yiv4325107315
#yiv4325107315ygrp-sponsor #yiv4325107315ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv4325107315
#yiv4325107315ygrp-sponsor #yiv4325107315ov ul {margin:0;padding:0 0 0
8px;}#yiv4325107315 #yiv4325107315ygrp-text
{font-family:Georgia;}#yiv4325107315 #yiv4325107315ygrp-text p {margin:0 0 1em
0;}#yiv4325107315 #yiv4325107315ygrp-text tt {font-size:120%;}#yiv4325107315
#yiv4325107315ygrp-vital ul li:last-child {border-right:none
!important;}#yiv4325107315
