Itheyibhile yePivot ye-Excel: umthambo osisiseko

Ukuqonda ngcono iinjongo kunye neziphumo zokusebenzisa iPivotTable kwi-Excel, makhe sibone isikhokelo senyathelo nenyathelo sendlela yokwenza iPivotTable kwi-Excel.

Kulo mzekelo olula sisebenzisa i-spreadsheet, edwelisa idatha yokuthengisa yenkampani.

I-spreadsheet ibonisa umhla wokuthengisa, igama lomthengisi, iphondo, icandelo kunye nengeniso.

Lo mzekelo ulandelayo wenza itheyibhile yepivot ebonisa ukuthengiswa okupheleleyo kwinyanga nganye yonyaka, echithwa yiphondo lokuthengisa kunye nommeli wokuthengisa. Inkqubo yokuyila le theyibhile yepivot ngolu hlobo lulandelayo:

1. Khetha nayiphi na iseli ngaphakathi koluhlu lwedatha o ikhetha lonke uluhlu lwedatha oluza kusetyenziswa kwitheyibhile yepivot.
2. Cofa iqhosha lePivotTable, elibekwe ngaphakathi kweqela elithi "Iitheyibhile", kwindawo ethi "Faka" yeribhoni ye-Excel.

3. Uya kuboniswa ngebhokisi yencoko ethi "Yenza iPivotTable".

Qinisekisa ukuba uluhlu olukhethiweyo lubhekiselele kuluhlu lweeseli ofuna ukuzisebenzisa kwitafile ye-pivot (ukuba udala itafile, njengoko kumzekelo, yonke into ilula kuba uya kubhekisela kwitafile kwaye ungasayi kubaququzeleli).

Kukwakho nokhetho olubuzayo ukuba ufuna ukubeka phi itafile yepivot. Oku kukuvumela ukuba ubeke itafile yepivot kwiphepha lomsebenzi elikhankanyiweyo. Ngaphandle koko, khetha ukhetho lwangaphambilidefiNita entsha iphepha lomsebenzi .

Cofa ku OK .

4. Ngoku uya kunikwa enye itafile yepivot blank kunye nePivotTable Field Uluhlu lwemisebenzi, equlathe imihlaba emininzi yedata. Nceda uqaphele ukuba ezi zihloko ze-spreadsheet sokuqala sedatha.

Sifuna i itafile yepivot ibonisa iimali zedatha yentengiso yenyanga nganye, ecazululwe ngummandla kunye nommeli weentengiso.

Ke ngoko, ukusuka kuluhlu lwemisebenzi ye "PivotTable Field":

• Tsala indawo "Date” kwindawo ephawulwe “Rows";
• Tsala indawo "Sales” kwindawo ephawulwe “Values Σ";
• Tsala indawo "Province” kwindawo ephawulwe “Columns";
• Tsala i “Seller“. kwindawo ebizwa ngokuba"Columns".

5. Itheyibhile ye-pivot enesiphumo iya kuhlaliswa ngeetotali zeentengiso zemihla ngemihla kwindawo nganye yokuthengisa kunye nommeli ngamnye wentengiso, njengoko kubonisiwe ngezantsi.

Njengoko ubona, imihla sele iqokelelwe ngenyanga, kunye nenani elipheleleyo leemali (olu luhlu oluzenzekelayo luxhomekeke kuguqulelo lwe-Excel, kunye neenguqulelo zangaphambili kwakuyimfuneko ukuba iqela ngenyanga, ngesandla).

Unokuseta izimbo kwiiseli, ezifana nemali yamanani kuba zizixa zengeniso.

Izihluzi zeNgxelo yePivotTable

Isihluzi sengxelo yePivotTable ikuvumela ukuba ujonge idatha yexabiso elinye okanye ukhetho lwamaxabiso achaziweyo kwimimandla yedatha.

Umzekelo, kwiPivotTable yangaphambili, unokubona kuphela idatha ngommandla wokuthengisa, njengephondo.

Ukujonga kuphela idatha yephondo laseTurin (TO), buyela kwi-task panel ye-"PivotTable Field List" kwaye utsale i-header yecandelo elithi "Province" kwindawo ethi "Report Filter" (okanye "Izihluzi").

Uya kubona ukuba indawo "yePhondo" ivela phezulu kwitafile yepivot. Sebenzisa uluhlu oluhlayo kulo mmandla ukukhetha iphondo laseTurin. Itheyibhile yepivot enesiphumo ibonisa iintengiso kuphela kwiphondo laseTurin.

Unokujonga ngokukhawuleza ukuthengisa kwingingqi yasePiedmont ngokukhetha onke amaPhondo ayinxalenye yengingqi yePiedmont kwimenyu eyehlayo.

Ercole Palmeri