txheem
Feem ntau yuav tsum tau ua pab pawg hauv ib lub rooj pivot los ntawm kab lossis kab ntawv. Rau cov lej muaj txiaj ntsig, Excel tuaj yeem ua qhov no tau txais (nrog rau hnub thiab sijhawm). Qhov no yog qhia hauv qab no nrog piv txwv.
Piv txwv 1: Pab pawg hauv lub rooj pivot los ntawm hnub
Xav tias peb tau tsim PivotTable (raws li hauv daim duab hauv qab no) uas qhia cov ntaub ntawv muag khoom rau txhua hnub ntawm thawj peb lub hlis twg xyoo 2016.
Yog tias koj xav ua pab pawg muag cov ntaub ntawv los ntawm lub hli, koj tuaj yeem ua nws li no:
- Txoj cai-nias ntawm sab laug ntawm lub rooj pivot (kem nrog hnub) thiab xaiv cov lus txib Group (Pab). Ib lub dialog box yuav tshwm sim Kev sib koom ua ke (Pab pawg) rau hnub.
- xaiv Hlis (Lub hli) thiab nias OK. Cov ntaub ntawv cov lus yuav muab ua pawg raws li lub hli raws li qhia hauv cov lus pivot hauv qab no.
Piv txwv 2: Muab pivotTable los ntawm Range
Xav tias peb tau tsim PivotTable (raws li hauv daim duab hauv qab no) uas pab pawg cov npe ntawm 150 tus menyuam yaus los ntawm hnub nyoog. Cov pab pawg raug faib los ntawm hnub nyoog ntawm 5 txog 16 xyoo.
Yog tias koj xav mus ntxiv thiab muab cov hnub nyoog ua ke rau hauv pawg 5-8 xyoo, 9-12 xyoo thiab 13-16 xyoo, koj tuaj yeem ua qhov no:
- Txoj cai-nias ntawm sab laug ntawm lub rooj pivot (kem nrog hnub nyoog) thiab xaiv cov lus txib Group (Pab). Ib lub dialog box yuav tshwm sim Kev sib koom ua ke (Pab pawg) rau cov lej. Excel yuav cia li sau rau hauv daim teb Txij thaum (Pib Thaum) thiab On (Xaiv Ntawm) nrog qhov tsawg kawg nkaus thiab siab tshaj qhov tseem ceeb ntawm peb cov ntaub ntawv thawj zaug (hauv peb qhov piv txwv, cov no yog 5 thiab 16).
- Peb xav muab cov hnub nyoog ua ke rau hauv pawg ntawm 4 xyoos, yog li ntawd, hauv thaj chaw Nrog ib kauj ruam (Los ntawm) sau tus nqi 4. Nyem OK.Yog li ntawd, cov hnub nyoog yuav muab faib ua pawg pib txij li 5-8 xyoos thiab tom qab ntawd nce mus txog 4 xyoos. Qhov tshwm sim yog lub rooj zoo li no:
Yuav ua li cas ungroup lub rooj pivot
Txhawm rau ungroup qhov tseem ceeb hauv lub rooj pivot:
- Txoj cai-nias rau ntawm kab laug sab ntawm lub rooj pivot (kab uas muaj cov txiaj ntsig sib faib);
- Hauv cov ntawv qhia zaub mov uas tshwm, nyem Rhuav tshem (Ungroup).
Feem ntau yuam kev thaum muab pawg hauv PivotTable
Yuam kev thaum ua pab pawg hauv lub rooj pivot: Cov khoom xaiv tsis tuaj yeem muab tso rau hauv ib pab pawg (Tsis tuaj yeem pab pawg xaiv ntawd).
Qee zaum thaum koj sim ua pab pawg hauv lub rooj pivot, nws hloov tawm tias cov lus txib Group (Pab pawg) hauv cov ntawv qhia zaub mov tsis ua haujlwm, lossis lub thawv ntawv yuam kev tshwm Cov khoom xaiv tsis tuaj yeem muab tso rau hauv ib pab pawg (Tsis tuaj yeem pab pawg xaiv ntawd). Qhov no tshwm sim feem ntau vim hais tias ib kem cov ntaub ntawv nyob rau hauv lub qhov chaw lub rooj muaj cov uas tsis yog-tus nqi los yog yuam kev. Txhawm rau txhim kho qhov no, koj yuav tsum tau ntxig cov lej lossis cov hnub tsis yog cov lej.
Tom qab ntawd txoj nyem rau ntawm lub rooj pivot thiab nyem Hloov tshiab & Txuag (tshiab). Cov ntaub ntawv hauv PivotTable yuav raug hloov kho thiab kab lossis kab ke yuav tsum tam sim no muaj.