Ha re qaleng ka potso e tloaelehileng haholo:Tafole ea pivot ho Excel ke eng?«
Litafole tsa Pivot ho Excel thusa ho akaretsa lintlha tse ngata tafoleng ea papiso. Sena se hlalosoa hantle ka mohlala.
Ha re re k'hamphani e bolokile tafole ea thekiso e entsoeng karolong ea pele ea 2016. Tafole e na le data: letsatsi la thekiso (letsatsi), nomoro ea invoice (Ref), chelete ea invoice (tjhelete), lebitso la morekisi (Sales Rep.) le sebaka sa thekiso (sebakeng). Tafole ena e shebahala tjena:
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | letsatsi | Ref | tjhelete | Sales Rep. | sebakeng |
| 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 | ... | ... | ... | ... | ... |
Tafole ea pivot ho Excel e ka akaretsa lintlha tse hlahisitsoeng tafoleng e fanoeng, e bonts'a palo ea lirekoto kapa kakaretso ea boleng kholomong efe kapa efe. Mohlala, tafole ena ea pivot e bonts'a kakaretso ea thekiso ea e mong le e mong oa barekisi ba bane bakeng sa kotara ea pele ea 2016:
Ka tlase ho na le tafole e rarahaneng ea pivot. Tafoleng ena, kakaretso ea thekiso ea morekisi e mong le e mong e arotsoe ka khoeli:
Molemo o mong oa Excel PivotTables ke hore li ka sebelisoa ho ntša data kapele karolong efe kapa efe ea tafole. Mohlala, haeba u batla ho bona lenane la thekiso ea morekisi ka lebitso la fane Brown Pherekhong 2016 (Jan), tobetsa habeli feela seleng e emelang boleng bona (tafoleng e kaholimo, boleng bona $ 28,741)
Sena se tla theha tafole e ncha ho Excel (joalo ka ha ho bonts'itsoe ka tlase) e thathamisang thekiso eohle ea morekisi ka lifane. Brown ka Pherekhong 2016.
Hajoale, ha re bue ka hore na litafole tsa pivot tse bontšitsoeng ka holimo li entsoe joang. Sepheo se seholo sa karolo ea pele ea thupelo ke ho araba potso e reng: "Tafole ea pivot ho Excel ke eng?“. Likarolong tse latelang tsa thuto, re tla ithuta ho etsa litafole tse joalo.★
★ Bala haholoanyane ka litafole tsa pivot: → Litafole tsa Pivot ho Excel - tutorial