Ithebula le-Excel Pivot: ukuzivocavoca okuyisisekelo

Ukuze uqonde kangcono izinjongo nemiphumela yokusebenzisa i-PivotTable ku-Excel, ake sibone inkomba yesinyathelo nesinyathelo sendlela yokudala i-PivotTable ku-Excel.

Kulesi sibonelo esilula sisebenzisa ispredishithi, esibala idatha yokuthengisa yenkampani.

Ispredishithi sibonisa usuku lokuthengisa, igama lomthengisi, isifundazwe, umkhakha kanye nenzuzo.

Isibonelo esilandelayo sidala ithebula le-pivot elibonisa inani eliphelele lokuthengiswa kwenyanga ngayinye yonyaka, elihlukaniswa isifundazwe sokuthengisa kanye nommeli wezentengiso. Inqubo yokudala leli thebula le-pivot imi kanje:

1. Khetha noma iyiphi iseli ngaphakathi kwebanga ledatha o ikhetha lonke ibanga ledatha elizosetshenziswa kuthebula le-pivot. (Qaphela: Uma ukhetha iseli eyodwa ebangeni ledatha, i-Excel izohlonza ngokuzenzakalelayo bese ikhetha lonke ububanzi bedatha yethebula le-pivot.)
2. Chofoza inkinobho ye-PivotTable, etholakala ngaphakathi kweqembu elithi “Amathebula”, kuthebhu ethi “Faka” yeribhoni ye-Excel.

3. Uzokwethulwa ngebhokisi lengxoxo elithi “Dala i-PivotTable”

Qinisekisa ukuthi ububanzi obukhethiwe bubhekisela ebangeni lamaseli ofuna ukulisebenzisela ithebula le-pivot (uma udala ithebula, njengakusibonelo, yonke into ilula ngoba uzobhekisela kuthebula futhi ungabe usabhekisela kumazixhumanisi).

Kukhona futhi inketho ekubuza ukuthi ufuna ukubeka kuphi ithebula le-pivot. Lokhu kukuvumela ukuthi ubeke ithebula le-pivot ekhasini lomsebenzi elishiwo. Uma kungenjalo, khetha inketho yangaphambilidefii-rivet entsha ishidi lokusebenza .

Qhafaza OK .

4. Manje uzonikezwa eyodwa ithebula le-pivot blank kanye nefasitelana lemisebenzi ye-PivotTable Field List, equkethe izinkundla ezimbalwa zedatha. Sicela uqaphele ukuthi lezi izihloko zesipredishithi sedatha sokuqala.

Sifuna ithebula le-pivot ibonisa isamba sedatha yokuthengisa yenyanga ngayinye, ehlukaniswa ngesifunda nommeleli wokuthengisa.

Ngakho-ke, kusukela kufasitelana le-“PivotTable Field List”:

• Hudula inkambu "Date” endaweni ephawulwe ukuthi “Rows";
• Hudula inkambu "Sales” endaweni ephawulwe ukuthi “Values Σ";
• Hudula inkambu "Province” endaweni ephawulwe ukuthi “Columns";
• Hudula "Seller“. endaweni ebizwa ngokuthi"Columns".

5. Ithebula le-pivot elizoba umphumela lizogcwaliswa ngamasamba okuthengisa ansuku zonke endaweni ngayinye yokuthengisa kanye nomele wezentengiso ngamunye, njengoba kuboniswe ngezansi.

Njengoba ubona, izinsuku sezivele ziqoqwe ngenyanga, ngenani eliphelele elilinganiselwe lamanani (lokhu kuqoqwa okuzenzakalelayo kuncike enguqulweni ye-Excel, ngezinguqulo zangaphambilini bekudingeka ukuhlanganisa ngenyanga, ngesandla).

Ungasetha izitayela kumaseli, njengohlobo lwemali lwezinombolo ngoba zingamanani emali engenayo.

Izihlungi Zombiko we-PivotTable

Isihlungi sombiko we-PivotTable sikuvumela ukuthi ubuke idatha yenani elilodwa noma ukukhethwa kwamanani ashiwo ezinkambini zedatha.

Isibonelo, ku-PivotTable yangaphambilini, ungabona kuphela idatha ngendawo yokuthengisa, njengesifundazwe.

Ukuze ubuke kuphela idatha yesifundazwe sase-Turin (TO), buyela kufasitelana lemisebenzi elithi “PivotTable Field List” bese uhudula inkambu yesihloko esithi “Isifundazwe” endaweni ethi “Bika Isihlungi” (noma “Izihlungi”).

Uzobona ukuthi inkambu "yeSifundazwe" ivela phezulu kuthebula le-pivot. Sebenzisa uhlu lokudonsela phansi kulo mkhakha ukuze ukhethe isifundazwe saseTurin. Ithebula le-pivot eliwumphumela libonisa kuphela ukuthengiswa kwesifundazwe saseTurin.

Ungakwazi futhi ukubuka ngokushesha ukuthengiswa kwesifunda sase-Piedmont ngokukhetha zonke Izifundazwe eziyingxenye yesifunda sase-Piedmont kumenyu yokudonsela phansi.

Ercole Palmeri