Dear Mr Kid
Saya punya dua workbook, satu berisi tabel fakta dengan beberapa kolom2 yang
berisi rumus mayoritas vlookupWorkbook satu nya lagi berisi tabel dari hasil
get external data dan power pivot
Workbook yang berisi hasil get external data ukuran file nya lebih kecil dan
lebih cepat proses refresh data nya.
Apakah memang seperti itu ? Jika demikian, apakah lebih baik membuat tabel yang
saling mempunyai relasi dibandingkan membuat tabel fakta yang banyak kolom
rumusnya ?
On Friday, January 5, 2018 9:40 AM, "'Mr. Kid' mr.nm...@gmail.com
[belajar-excel]" <belajar-excel@yahoogroups.com> wrote:
1. Filternya langsung di kolom tanggal dalam pivot table
2. Refresh All tidak mengapa kok. Apalagi kalau tabel sumber datanya ada banyak
atau dari hasil get external data.
On Fri, Jan 5, 2018 at 9:26 AM, Zerlinda Seismica seism...@yahoo.com
[belajar-excel] <belajar-excel@yahoogroups.com> wrote:
Makasih Mr Kid dan Mbk Kiki atas saran dan masukannya...Mas Kid mau
tanya1. Karena sesuatu hal bisa gimana caranya yang item filter tanggal dganti
manual inputnya. Maksudnya klo perlu tanggal 1 Jan saya ketik aja 1 jan di cell
tertentu jd tidak pake slicer ato scrol2. Apa efek bahayanya klo pake refresh
all soalnya saya sring pake yang all bukannya kalo all data semuanya update
Mohon petujuuk dan sarannya lagi Mr Kid dan bapak ibu
WassalamSeismica
Pada Jumat, 5 Januari 2018 7:34, "'Mr. Kid' mr.nm...@gmail.com
[belajar-excel]" <belajar-excel@yahoogroups.com > menulis:
Wa'alaikumussalam wr wb
File terlampir.
Wassalamu'alaikum wr wb
Kid
2018-01-04 10:18 GMT+07:00 Zerlinda Seismica seism...@yahoo.com [belajar-excel]
<belajar-excel@yahoogroups.com >:
Assalamualaikum wrwb
Mohon maaf bapak ibu karena semangatnya saya izin diskusi dan bertanya
Memanfaatkan Data Pivot Tabel, bisa dilihat dilampiran untuk bisa jelasnya
WassalamSeismica
#yiv7155658768 #yiv7155658768 -- #yiv7155658768ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7155658768
#yiv7155658768ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7155658768
#yiv7155658768ygrp-mkp #yiv7155658768hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv7155658768 #yiv7155658768ygrp-mkp #yiv7155658768ads
{margin-bottom:10px;}#yiv7155658768 #yiv7155658768ygrp-mkp .yiv7155658768ad
{padding:0 0;}#yiv7155658768 #yiv7155658768ygrp-mkp .yiv7155658768ad p
{margin:0;}#yiv7155658768 #yiv7155658768ygrp-mkp .yiv7155658768ad a
{color:#0000ff;text-decoration:none;}#yiv7155658768 #yiv7155658768ygrp-sponsor
#yiv7155658768ygrp-lc {font-family:Arial;}#yiv7155658768
#yiv7155658768ygrp-sponsor #yiv7155658768ygrp-lc #yiv7155658768hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7155658768
#yiv7155658768ygrp-sponsor #yiv7155658768ygrp-lc .yiv7155658768ad
{margin-bottom:10px;padding:0 0;}#yiv7155658768 #yiv7155658768actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7155658768
#yiv7155658768activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7155658768
#yiv7155658768activity span {font-weight:700;}#yiv7155658768
#yiv7155658768activity span:first-child
{text-transform:uppercase;}#yiv7155658768 #yiv7155658768activity span a
{color:#5085b6;text-decoration:none;}#yiv7155658768 #yiv7155658768activity span
span {color:#ff7900;}#yiv7155658768 #yiv7155658768activity span
.yiv7155658768underline {text-decoration:underline;}#yiv7155658768
.yiv7155658768attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv7155658768 .yiv7155658768attach div a
{text-decoration:none;}#yiv7155658768 .yiv7155658768attach img
{border:none;padding-right:5px;}#yiv7155658768 .yiv7155658768attach label
{display:block;margin-bottom:5px;}#yiv7155658768 .yiv7155658768attach label a
{text-decoration:none;}#yiv7155658768 blockquote {margin:0 0 0
4px;}#yiv7155658768 .yiv7155658768bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv7155658768
.yiv7155658768bold a {text-decoration:none;}#yiv7155658768 dd.yiv7155658768last
p a {font-family:Verdana;font-weight:700;}#yiv7155658768 dd.yiv7155658768last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7155658768
dd.yiv7155658768last p span.yiv7155658768yshortcuts
{margin-right:0;}#yiv7155658768 div.yiv7155658768attach-table div div a
{text-decoration:none;}#yiv7155658768 div.yiv7155658768attach-table
{width:400px;}#yiv7155658768 div.yiv7155658768file-title a, #yiv7155658768
div.yiv7155658768file-title a:active, #yiv7155658768
div.yiv7155658768file-title a:hover, #yiv7155658768 div.yiv7155658768file-title
a:visited {text-decoration:none;}#yiv7155658768 div.yiv7155658768photo-title a,
#yiv7155658768 div.yiv7155658768photo-title a:active, #yiv7155658768
div.yiv7155658768photo-title a:hover, #yiv7155658768
div.yiv7155658768photo-title a:visited {text-decoration:none;}#yiv7155658768
div#yiv7155658768ygrp-mlmsg #yiv7155658768ygrp-msg p a
span.yiv7155658768yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7155658768
.yiv7155658768green {color:#628c2a;}#yiv7155658768 .yiv7155658768MsoNormal
{margin:0 0 0 0;}#yiv7155658768 o {font-size:0;}#yiv7155658768
#yiv7155658768photos div {float:left;width:72px;}#yiv7155658768
#yiv7155658768photos div div {border:1px solid
#666666;min-height:62px;overflow:hidden;width:62px;}#yiv7155658768
#yiv7155658768photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7155658768
#yiv7155658768reco-category {font-size:77%;}#yiv7155658768
#yiv7155658768reco-desc {font-size:77%;}#yiv7155658768 .yiv7155658768replbq
{margin:4px;}#yiv7155658768 #yiv7155658768ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv7155658768 #yiv7155658768ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv7155658768
#yiv7155658768ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv7155658768
#yiv7155658768ygrp-mlmsg select, #yiv7155658768 input, #yiv7155658768 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv7155658768
#yiv7155658768ygrp-mlmsg pre, #yiv7155658768 code {font:115%
monospace;}#yiv7155658768 #yiv7155658768ygrp-mlmsg *
{line-height:1.22em;}#yiv7155658768 #yiv7155658768ygrp-mlmsg #yiv7155658768logo
{padding-bottom:10px;}#yiv7155658768 #yiv7155658768ygrp-msg p a
{font-family:Verdana;}#yiv7155658768 #yiv7155658768ygrp-msg
p#yiv7155658768attach-count span {color:#1E66AE;font-weight:700;}#yiv7155658768
#yiv7155658768ygrp-reco #yiv7155658768reco-head
{color:#ff7900;font-weight:700;}#yiv7155658768 #yiv7155658768ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv7155658768 #yiv7155658768ygrp-sponsor
#yiv7155658768ov li a {font-size:130%;text-decoration:none;}#yiv7155658768
#yiv7155658768ygrp-sponsor #yiv7155658768ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv7155658768
#yiv7155658768ygrp-sponsor #yiv7155658768ov ul {margin:0;padding:0 0 0
8px;}#yiv7155658768 #yiv7155658768ygrp-text
{font-family:Georgia;}#yiv7155658768 #yiv7155658768ygrp-text p {margin:0 0 1em
0;}#yiv7155658768 #yiv7155658768ygrp-text tt {font-size:120%;}#yiv7155658768
#yiv7155658768ygrp-vital ul li:last-child {border-right:none
!important;}#yiv7155658768
