Pivot ntxhuav hauv Excel yog ntau yam kev tshaj tawm cov cuab yeej uas ua rau nws yooj yim rau rho tawm cov ntaub ntawv los ntawm cov ntxhuav loj ntawm cov ntaub ntawv yam tsis tas siv cov qauv. Pivot ntxhuav yog cov neeg siv khoom zoo heev. Lawv txav, lossis pivot, thaj chaw ntawm cov ntaub ntawv los ntawm ib qhov chaw mus rau lwm qhov kom cov ntaub ntawv tuaj yeem saib ntawm ntau txoj kev sib txawv.
Cov lus qhia hauv kab lus no siv rau Excel 2019, 2016, 2013, 2010; thiab Excel rau Mac.
Enter the Pivot Table Data
Thawj kauj ruam hauv kev tsim lub rooj pivot yog nkag mus rau cov ntaub ntawv rau hauv daim ntawv ua haujlwm. Ua raws li cov lus qhia no, nkag mus rau cov ntaub ntawv qhia hauv daim duab hauv qab no.
Kua cov ntsiab lus hauv qab no:
- Yam tsawg kawg peb kab ntawm cov ntaub ntawv yuav tsum tau tsim kom muaj lub rooj pivot.
- Nws yog ib qho tseem ceeb kom nkag mus rau cov ntaub ntawv kom raug. Cov teeb meem tshwm sim los ntawm cov ntaub ntawv tsis raug yog qhov muaj ntau yam teeb meem ntsig txog kev tswj cov ntaub ntawv.
- Txawm tsis muaj kab los yog kab ib sab thaum nkag mus rau cov ntaub ntawv. Qhov no suav nrog tsis tso cov kab dawb paug ntawm kab ntawv kab lus thiab thawj kab ntawm cov ntaub ntawv.
Create the Pivot Table
Ua raws cov kauj ruam no los tsim lub rooj pivot siv cov ntaub ntawv qhia:
- Highlight cells A2 to D12.
- Xaiv Insert.
- Nyob hauv pawg Tables, xaiv PivotTable txhawm rau qhib lub Tsim PivotTable dialog box.
- Xaiv Daim Ntawv Ua Haujlwm Tseem Ceeb rau qhov chaw ntawm lub rooj pivot.
- Muab tus cursor rau hauv lub thawv ntawv qhov chaw.
-
Xaiv xovtooj D15 hauv daim ntawv ua haujlwm kom nkag mus rau qhov kev siv xovtooj ntawm qhov chaw nyob.
Image - Xaiv OK.
Ib lub rooj pivot dawb paug tshwm rau ntawm daim ntawv ua haujlwm nrog rau sab saum toj sab laug ntawm lub rooj pivot hauv xov tooj D15. PivotTable Fields vaj huam sib luag qhib rau sab xis ntawm lub qhov rais Excel.
Nyob rau sab saum toj ntawm PivotTable Fields vaj huam sib luag yog cov npe teb (kem nqe lus) los ntawm cov ntaub ntawv. Cov ntaub ntawv thaj chaw hauv qab ntawm lub vaj huam sib luag yog txuas rau lub rooj pivot.
Ntxiv cov ntaub ntawv rau Pivot Table
Cov ntaub ntawv thaj chaw hauv PivotTable Fields vaj huam sib luag yog txuas rau cov chaw sib thooj ntawm lub rooj pivot. Thaum koj ntxiv cov npe teb rau thaj chaw cov ntaub ntawv, cov ntaub ntawv ntxiv rau lub rooj pivot. Nyob ntawm seb cov teb twg tau muab tso rau hauv cheeb tsam cov ntaub ntawv, cov txiaj ntsig sib txawv tau txais.
Koj muaj ob txoj kev xaiv thaum nws los ntxiv cov ntaub ntawv rau lub rooj pivot:
- Dag cov npe teb los ntawm PivotTable Fields vaj huam sib luag thiab muab tso rau ntawm lub rooj pivot hauv daim ntawv ua haujlwm.
- Dag cov npe teb mus rau hauv qab ntawm PivotTable Fields vaj huam sib luag thiab muab tso rau hauv cov ntaub ntawv cheeb tsam.
Dag cov npe nram qab no rau cov ntaub ntawv sau tseg:
- Tag nrho Muag rau thaj chaw lim.
- Region rau thaj tsam kab.
- Sales Rep rau thaj tsam kab.
- Orders rau thaj chaw muaj nuj nqis.
Filter the Pivot Table Data
Lub rooj pivot muaj cov cuab yeej lim dej ua ke uas kho cov txiaj ntsig tau pom hauv lub rooj pivot. Kev lim cov ntaub ntawv suav nrog kev siv cov qauv tshwj xeeb los txwv cov ntaub ntawv dab tsi tshwm sim los ntawm lub rooj pivot.
- Xaiv kab ntawv nqes hauv qab ntawm lub rooj pivot los qhib cov lim cov npe poob.
- Tshem tawm daim ntawv kos ntawm ib sab ntawm Xaiv Tag Nrho kom tshem cov cim kos ntawm txhua lub thawv hauv daim ntawv.
-
Tau qhov kos ib sab ntawm West thiab North.
Image - Xaiv OK.
Lub rooj pivot qhia qhov kev txiav txim tag nrho rau cov neeg muag khoom muag uas ua haujlwm nyob rau sab hnub poob thiab sab qaum teb.
Hloov cov Pivot Table Data
Txhawm rau hloov cov txiaj ntsig tau pom hauv lub rooj pivot:
-
Raws lub rooj pivot los ntawm rub cov ntaub ntawv teb los ntawm ib cheeb tsam cov ntaub ntawv mus rau lwm qhov hauv PivotTable Fields vaj huam sib luag.
Image Yog tias koj kaw PivotTable Fields pane, xaiv ib lub xovtooj ntawm lub rooj pivot thiab xaiv Tshaj tawm > Daim Ntawv Qhia.
- Thov lim kom tau txais cov txiaj ntsig xav tau.
