maaf, ini attachmentnya Best Regards, Fajar Fatahillah
On Wednesday, June 3, 2015 1:01 PM, "egidia seftyanaputri
[email protected] [belajar-excel]" <[email protected]> wrote:
Dear pak Fajar,
sambil menunggu jawaban dari yang lain, Putri coba ikut memberikan pandangan
ya..
Hal tersebut memungkinkan jika data source mengandung kolom yang berisi
perhitungan selisih antara tanggal data dengan tanggal laporan dibuat, bisa
menggunakan formula =Today() - tanggal_data.
Hasil perhitungan tersebut yang dimasukkan ke dalam field filter pada Pivot
Table.
Jika data source selalu bertambah setiap hari, ada baiknya memanfaatkan fitur
Excel Table atau List agar range data selalu bersifat dinamis mengikuti
pertambahan data yang ada.
cmiiw
regards,
-putri-
Pada 3 Juni 2015 10.55, Fajar Fatahillah [email protected]
[belajar-excel] <[email protected]> menulis:
Dear Master Excel,mau tanya, apakah bisa excel pivot hanya menampilkan
data 7 hari terakhir saja, sementara data hari tersebut bertambah setiap
harinya.Misal
data hari 1,2,3,4,5,6,7 junibesoknya 2,3,4,5,6,7,8seterusnya 3,4,5,6,7,8,9 data
sourcenya bertambah setiap harinya, namun yang ingin ditampilkan di pivot hanya
7 hari terakhir.
terima kasih atas perhatiannya.
Best Regards,
Fajar Fatahillah
--- Mods ---
File lampiran yang melebihi 250KB dilepas dari email. Penanya dipersilahkan
mengirim ulang file lampiran yang diusahakan maksimal 250KB dengan cara
me-reply email ini.
---------------
#yiv6938488510 #yiv6938488510 -- #yiv6938488510ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv6938488510
#yiv6938488510ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv6938488510
#yiv6938488510ygrp-mkp #yiv6938488510hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv6938488510 #yiv6938488510ygrp-mkp #yiv6938488510ads
{margin-bottom:10px;}#yiv6938488510 #yiv6938488510ygrp-mkp .yiv6938488510ad
{padding:0 0;}#yiv6938488510 #yiv6938488510ygrp-mkp .yiv6938488510ad p
{margin:0;}#yiv6938488510 #yiv6938488510ygrp-mkp .yiv6938488510ad a
{color:#0000ff;text-decoration:none;}#yiv6938488510 #yiv6938488510ygrp-sponsor
#yiv6938488510ygrp-lc {font-family:Arial;}#yiv6938488510
#yiv6938488510ygrp-sponsor #yiv6938488510ygrp-lc #yiv6938488510hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv6938488510
#yiv6938488510ygrp-sponsor #yiv6938488510ygrp-lc .yiv6938488510ad
{margin-bottom:10px;padding:0 0;}#yiv6938488510 #yiv6938488510actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv6938488510
#yiv6938488510activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv6938488510
#yiv6938488510activity span {font-weight:700;}#yiv6938488510
#yiv6938488510activity span:first-child
{text-transform:uppercase;}#yiv6938488510 #yiv6938488510activity span a
{color:#5085b6;text-decoration:none;}#yiv6938488510 #yiv6938488510activity span
span {color:#ff7900;}#yiv6938488510 #yiv6938488510activity span
.yiv6938488510underline {text-decoration:underline;}#yiv6938488510
.yiv6938488510attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv6938488510 .yiv6938488510attach div a
{text-decoration:none;}#yiv6938488510 .yiv6938488510attach img
{border:none;padding-right:5px;}#yiv6938488510 .yiv6938488510attach label
{display:block;margin-bottom:5px;}#yiv6938488510 .yiv6938488510attach label a
{text-decoration:none;}#yiv6938488510 blockquote {margin:0 0 0
4px;}#yiv6938488510 .yiv6938488510bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv6938488510
.yiv6938488510bold a {text-decoration:none;}#yiv6938488510 dd.yiv6938488510last
p a {font-family:Verdana;font-weight:700;}#yiv6938488510 dd.yiv6938488510last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv6938488510
dd.yiv6938488510last p span.yiv6938488510yshortcuts
{margin-right:0;}#yiv6938488510 div.yiv6938488510attach-table div div a
{text-decoration:none;}#yiv6938488510 div.yiv6938488510attach-table
{width:400px;}#yiv6938488510 div.yiv6938488510file-title a, #yiv6938488510
div.yiv6938488510file-title a:active, #yiv6938488510
div.yiv6938488510file-title a:hover, #yiv6938488510 div.yiv6938488510file-title
a:visited {text-decoration:none;}#yiv6938488510 div.yiv6938488510photo-title a,
#yiv6938488510 div.yiv6938488510photo-title a:active, #yiv6938488510
div.yiv6938488510photo-title a:hover, #yiv6938488510
div.yiv6938488510photo-title a:visited {text-decoration:none;}#yiv6938488510
div#yiv6938488510ygrp-mlmsg #yiv6938488510ygrp-msg p a
span.yiv6938488510yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv6938488510
.yiv6938488510green {color:#628c2a;}#yiv6938488510 .yiv6938488510MsoNormal
{margin:0 0 0 0;}#yiv6938488510 o {font-size:0;}#yiv6938488510
#yiv6938488510photos div {float:left;width:72px;}#yiv6938488510
#yiv6938488510photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv6938488510
#yiv6938488510photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv6938488510
#yiv6938488510reco-category {font-size:77%;}#yiv6938488510
#yiv6938488510reco-desc {font-size:77%;}#yiv6938488510 .yiv6938488510replbq
{margin:4px;}#yiv6938488510 #yiv6938488510ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv6938488510 #yiv6938488510ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv6938488510
#yiv6938488510ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv6938488510
#yiv6938488510ygrp-mlmsg select, #yiv6938488510 input, #yiv6938488510 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv6938488510
#yiv6938488510ygrp-mlmsg pre, #yiv6938488510 code {font:115%
monospace;}#yiv6938488510 #yiv6938488510ygrp-mlmsg *
{line-height:1.22em;}#yiv6938488510 #yiv6938488510ygrp-mlmsg #yiv6938488510logo
{padding-bottom:10px;}#yiv6938488510 #yiv6938488510ygrp-msg p a
{font-family:Verdana;}#yiv6938488510 #yiv6938488510ygrp-msg
p#yiv6938488510attach-count span {color:#1E66AE;font-weight:700;}#yiv6938488510
#yiv6938488510ygrp-reco #yiv6938488510reco-head
{color:#ff7900;font-weight:700;}#yiv6938488510 #yiv6938488510ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv6938488510 #yiv6938488510ygrp-sponsor
#yiv6938488510ov li a {font-size:130%;text-decoration:none;}#yiv6938488510
#yiv6938488510ygrp-sponsor #yiv6938488510ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv6938488510
#yiv6938488510ygrp-sponsor #yiv6938488510ov ul {margin:0;padding:0 0 0
8px;}#yiv6938488510 #yiv6938488510ygrp-text
{font-family:Georgia;}#yiv6938488510 #yiv6938488510ygrp-text p {margin:0 0 1em
0;}#yiv6938488510 #yiv6938488510ygrp-text tt {font-size:120%;}#yiv6938488510
#yiv6938488510ygrp-vital ul li:last-child {border-right:none
!important;}#yiv6938488510
contoh pivot 3.xlsx
Description: MS-Excel 2007 spreadsheet
