Ake siqale ngombuzo ovame kakhulu:Liyini ithebula le-pivot ku-Excel?«
Amathebula e-Pivot ku-Excel ukusiza ukufingqa amanani amakhulu edatha kuthebula lokuqhathanisa. Lokhu kuchazwa kangcono ngesibonelo.
Ake sithi inkampani igcine itafula lokuthengisa elenziwe ngekota yokuqala ka-2016. Ithebula liqukethe idatha: usuku lokuthengisa (Usuku), inombolo ye-invoyisi (I-invoyisi Ref), inani le-invoyisi (Inani le), igama lomthengisi (Omele ezokudayisa.) nendawo yokuthengisa (Isifunda). Leli thebula libukeka kanje:
A | B | C | D | E | |
---|---|---|---|---|---|
1 | Usuku | I-invoyisi Ref | Inani le | Omele ezokudayisa. | Isifunda |
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 | ... | ... | ... | ... | ... |
Ithebula le-pivot ku-Excel lingafingqa idatha ethulwe kuthebula elinikeziwe, libonise inani lamarekhodi noma isamba samanani kunoma iyiphi ikholomu. Isibonelo, leli thebula le-pivot libonisa inani eliphelele lokuthengisa komuntu ngamunye kwabane ngekota yokuqala ka-2016:
Ngezansi kunethebula le-pivot eliyinkimbinkimbi. Kuleli thebula, isamba sokuthengisa somthengisi ngamunye sihlukaniswa ngenyanga:
Enye inzuzo ye-Excel PivotTables ukuthi ingasetshenziswa ukukhipha idatha ngokushesha kunoma iyiphi ingxenye yetafula. Isibonelo, uma ufuna ukubona uhlu lokuthengisa lomthengisi ngesibongo Brown Januwari 2016 (uJan), vele uchofoze kabili kuseli elimele leli nani (kuthebula elingenhla, leli nani $ 28,741)
Lokhu kuzodala ithebula elisha ku-Excel (njengoba kukhonjisiwe ngezansi) elibala zonke izidayisi zomdayisi ngesibongo. Brown ngoJanuwari 2016.
Okwamanje, asikhulumi ngokuthi amathebula e-pivot aboniswe ngenhla adalwe kanjani. Umgomo oyinhloko wengxenye yokuqala yesifundo ukuphendula umbuzo: “Liyini ithebula le-pivot ku-Excel?“. Ezingxenyeni ezilandelayo zesifundo, sizofunda indlela yokudala amathebula anjalo.★
★ Funda kabanzi mayelana namathebula e-pivot: → Amathebula e-Pivot ku-Excel - okokufundisa