Cia peb pib nrog cov lus nug feem ntau:Dab tsi yog lub rooj pivot hauv Excel?«
Pivot Tables hauv Excel pab kom xaus cov ntaub ntawv loj hauv ib lub rooj sib piv. Qhov no yog qhov zoo tshaj plaws piav qhia nrog ib qho piv txwv.
Piv txwv tias ib lub tuam txhab tau khaws ib lub rooj muag khoom hauv thawj peb lub hlis twg ntawm 2016. Lub rooj muaj cov ntaub ntawv: hnub tim muag (Hnub), invoice number (Invoice Ref), tus nqi them nqi (nyiaj), tus neeg muag khoom npe (Muag Rep.) thiab thaj chaw muag khoom (cheeb tsam). Lub rooj no zoo li no:
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Hnub | Invoice Ref | nyiaj | Muag Rep. | cheeb tsam |
| 2 | 01/01/2016 | 2016 - 0001 | $ 819 | Barnes | North |
| 3 | 01/01/2016 | 2016 - 0002 | $ 456 | Brown | South |
| 4 | 01/01/2016 | 2016 - 0003 | $ 538 | Jones | South |
| 5 | 01/01/2016 | 2016 - 0004 | $ 1,009 | Barnes | North |
| 6 | 01/02/2016 | 2016 - 0005 | $ 486 | Jones | South |
| 7 | 01/02/2016 | 2016 - 0006 | $ 948 | Smith | North |
| 8 | 01/02/2016 | 2016 - 0007 | $ 740 | Barnes | North |
| 9 | 01/03/2016 | 2016 - 0008 | $ 543 | Smith | North |
| 10 | 01/03/2016 | 2016 - 0009 | $ 820 | Brown | South |
| 11 | ... | ... | ... | ... | ... |
Lub rooj pivot hauv Excel tuaj yeem sau cov ntaub ntawv nthuav tawm hauv ib lub rooj, qhia cov naj npawb ntawm cov ntaub ntawv lossis cov lej ntawm qhov tseem ceeb hauv txhua kab. Piv txwv li, cov lus pivot no qhia tag nrho cov muag khoom ntawm txhua tus ntawm plaub tus neeg muag khoom rau thawj peb lub hlis twg ntawm 2016:
Hauv qab no yog lub rooj sib tham ntau dua. Hauv cov lus no, qhov kev muag khoom tag nrho ntawm txhua tus neeg muag khoom tau tawg los ntawm lub hli:
Lwm qhov zoo dua ntawm Excel PivotTables yog tias lawv tuaj yeem siv tau sai sai tshem cov ntaub ntawv los ntawm ib feem ntawm lub rooj. Piv txwv li, yog tias koj xav pom daim ntawv teev npe ntawm tus neeg muag khoom los ntawm lub xeem Brown Lub Ib Hlis 2016 (Jan), tsuas yog nyem ob npaug rau ntawm lub xov tooj ntawm tes uas sawv cev rau tus nqi no (hauv cov lus saum toj no, tus nqi no $ 28,741)
Qhov no yuav tsim ib lub rooj tshiab hauv Excel (raws li qhia hauv qab no) uas teev tag nrho cov neeg muag khoom muag los ntawm lub xeem. Brown rau lub Ib Hlis 2016.
Txog tam sim no, peb tsis tau tham txog yuav ua li cas cov lus pivot qhia saum toj no tau tsim. Lub hom phiaj tseem ceeb ntawm thawj ntu ntawm kev qhia yog los teb cov lus nug: "Dab tsi yog lub rooj pivot hauv Excel?". Nyob rau hauv cov nram qab no qhov chaw ntawm qhov kev qhia, peb yuav kawm yuav ua li cas los tsim cov ntxhuav.★
★ Nyeem ntxiv txog cov lus pivot: → Pivot ntxhuav hauv Excel – nyeem