Thaum ua hauj lwm nrog cov lus pivot loj, koj feem ntau yuav tsum tau ua kom yooj yim rau lawv, lim qee cov ntaub ntawv kom tsis txhob poob rau hauv cov lej. Txoj hauv kev yooj yim tshaj plaws los ua qhov no yog muab qee qhov chaw hauv cheeb tsam lim (hauv cov qauv ua ntej xyoo 2007 nws tau hu ua nplooj ntawv cheeb tsam) thiab xaiv tsuas yog cov txiaj ntsig tsim nyog los ntawm cov npe poob:
Qhov tsis zoo ntawm txoj kev no yog pom tseeb:
- Thaum xaiv ntau yam khoom, lawv tsis pom, tab sis cov ntawv "(ntau yam khoom)" pom. Tsis txhob siv tus phooj ywg.
- Ib daim ntawv qhia lim yog hardwired rau ib lub rooj pivot. Yog tias peb muaj ob peb lub rooj pivot (thiab feem ntau qhov teeb meem tsis txwv rau ib qho), ces rau txhua tus (!) Koj yuav tau tsim koj tus kheej lim thiab rau txhua tus koj yuav tau qhib nws, zuam tawm cov ntsiab lus tsim nyog thiab nias OK. Tsis yooj yim heev, kuv txawm pom cov neeg nyiam sau ntawv tshwj xeeb rau lub hom phiaj no.
Yog tias koj muaj Excel 2010, ces txhua yam no tuaj yeem ua tau zoo dua - siv slices (slicers). slices yog ib qho yooj yim khawm graphical sawv cev ntawm kev sib tham sib qhia cov ntxaij lim dej rau PivotTable lossis Daim Ntawv Qhia:
Lub tshuab hlais zoo li cov khoom sib cais (xws li daim duab lossis daim duab), tsis cuam tshuam nrog cov hlwb, thiab tso tawm saum daim ntawv, uas ua rau nws yooj yim txav mus los. Txhawm rau tsim ib lub slicer rau lub rooj pivot tam sim no, mus rau tab tsis (Kev xaiv) thiab hauv ib pab pawg Cais thiab lim (Xaiv thiab lim) nyem lub pob Muab tshuaj txhuam (Ntxig slicer):
Tam sim no, thaum xaiv lossis deselecting cov ntsiab lus (koj tuaj yeem siv cov yuam sij Ctrl и ua haujlwm, as well as swiping with the left mouse button pressed to select in bulk) lub pivot rooj yuav tso saib tsuas yog cov ntaub ntawv lim rau cov khoom xaiv. Ib qho ntxiv zoo nuance yog tias daim hlais hauv cov xim sib txawv qhia tsis tau tsuas yog xaiv, tab sis kuj tsis muaj cov ntsiab lus uas tsis muaj ib qho nqi hauv lub rooj:
Yog tias koj siv ntau lub slicers, qhov no yuav tso cai rau koj kom sai thiab pom kev sib raug zoo ntawm cov ntaub ntawv ntsiab lus:
Tib lub slicer tuaj yeem txuas tau yooj yim rau ntau PivotTables thiab PivotCharts siv cov tsis (Kev xaiv) khawm PivotTable Sib Txuas (Pivot rooj sib txuas)uas qhib qhov sib thooj dialog box:
Tom qab ntawd qhov kev xaiv ntawm cov ntsiab lus ntawm ib daim yuav cuam tshuam rau ntau lub rooj thiab cov duab kos ib zaug, tej zaum txawm nyob ntawm cov nplooj ntawv sib txawv.
Cov qauv tsim tsis tau hnov qab ib yam. Txhawm rau tsim cov ntawv hlais ntawm ib lub tab constructor (Tsim) Muaj ntau ntau inline style:
... thiab muaj peev xwm los tsim koj tus kheej tsim kev xaiv:
Thiab hauv "pivot rooj - pivot daim ntawv - hlais" ua ke, tag nrho cov no zoo li zoo kawg nkaus:
- Dab tsi yog pivot ntxhuav thiab yuav ua li cas los tsim lawv
- Muab cov lej thiab hnub tim nrog cov kauj ruam xav tau hauv cov lus pivot
- Tsim ib Daim Ntawv Qhia PivotTable ntawm Ntau Qhov Ntau Ntawm Cov Ntaub Ntawv
- Teeb tsa kev suav hauv PivotTables