Ichi chikamu chedzidziso inotsanangura maitiro ekugadzira PivotTable muExcel. Ichi chinyorwa chakanyorerwa Excel 2007 (pamwe neshanduro dzakazotevera). Mirayiridzo yezvinyorwa zvekare zveExcel inogona kuwanikwa mune imwe nyaya: Maitiro ekugadzira PivotTable muExcel 2003?
Semuenzaniso, funga tafura inotevera, ine data yekutengesa yekambani yekota yekutanga ye2016:
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | zuva | Invoice Ref | uwandu | Mutengesi. | Nharaunda |
| 2 | 01/01/2016 | 2016 - 0001 | $ 819 | Barnes | Mawodzanyemba |
| 3 | 01/01/2016 | 2016 - 0002 | $ 456 | Bhurawuni | Chamhembe |
| 4 | 01/01/2016 | 2016 - 0003 | $ 538 | Jones | Chamhembe |
| 5 | 01/01/2016 | 2016 - 0004 | $ 1,009 | Barnes | Mawodzanyemba |
| 6 | 01/02/2016 | 2016 - 0005 | $ 486 | Jones | Chamhembe |
| 7 | 01/02/2016 | 2016 - 0006 | $ 948 | Smith | Mawodzanyemba |
| 8 | 01/02/2016 | 2016 - 0007 | $ 740 | Barnes | Mawodzanyemba |
| 9 | 01/03/2016 | 2016 - 0008 | $ 543 | Smith | Mawodzanyemba |
| 10 | 01/03/2016 | 2016 - 0009 | $ 820 | Bhurawuni | Chamhembe |
| 11 | ... | ... | ... | ... | ... |
Kutanga, ngatigadzire tafura yepivot yakapfava iyo inoratidza kutengesa kwese kweumwe neumwe wevatengesi zvinoenderana netafura iri pamusoro. Kuti uite izvi, ita zvinotevera:
- Sarudza chero sero kubva padhata renji kana huwandu hwese huchashandiswa mutafura yepivot.Caution: Kana ukasarudza sero rimwe chete kubva padhata renji, Excel inozoona yega uye sarudza iyo yese data renji yePivotTable. Kuti Excel isarudze renji nenzira kwayo, zvinotevera zvinofanirwa kuzadzikiswa:
- Koramu yega yega mudhadha renji inofanirwa kunge iine zita rayo rakasiyana;
- Iyo data haifanirwe kunge iine mitsetse isina chinhu.
- Kudzvanya bhatani pfupiso tafura (Pivot Table) muchikamu matafura (Tables) tab Insert (Isa) Excel menyu ribhoni.
- Bhokisi renhaurirano richaonekwa pachiratidziri. Gadzira PivotTable (Gadzira PivotTable) sezvakaratidzwa mumufananidzo uri pasi apa.
Ita shuwa kuti yakasarudzwa chiyero inoenderana nehuwandu hwemasero anofanirwa kushandiswa kugadzira iyo PivotTable. Pano iwe unogona zvakare kutsanangura kuti tafura yepivot yakagadzirwa inofanira kuiswa kupi. Unogona kusarudza pepa riripo kuti uise tafura yepivot pairi, kana sarudzo - Kubepa idzva (New worksheet). tinya OK. - Tafura yepivot isina chinhu ichaonekwa, pamwe nepaneru Pivot tafura minda (Pivot Tafura Munda Rondedzero) ine akawanda data data. Ziva kuti aya ndiwo misoro kubva kune yekutanga dhatabheti.
- Mune mapaneru Pivot tafura minda (Pivot Table Field List):
- Dragora uye udonese Mutengesi. kunzvimbo Rows (Row Labels);
- Dragora uye udonese uwandu в Zvinokosha (Values);
- Tinoongorora: in Zvinokosha (Values) inofanira kuva yakakosha Nhamba yemunda Mari (Huwandu hweMari), а не Mari nemunda Mari (Kuverengwa Kwemari).
Mumuenzaniso uyu, chikamu uwandu ine nhamba dzinokosha, saka nzvimbo yacho Σ Zvinokosha (Σ Values) ichasarudzwa nekusingaperi Nhamba yemunda Mari (Chimwe chemari). Kana muchikamu uwandu ichava nenhamba dzisiri-nhamba kana dzisina chinhu, ipapo iyo default pivot tafura inogona kusarudzwa Mari nemunda Mari (Kuverengwa Kwemari). Kana izvi zvikaitika, iwe unogona kushandura huwandu kune huwandu sezvinotevera:
- Mu Σ Zvinokosha (Σ Values) tinya pa Mari nemunda Mari (Kuverenga Kwemari) uye sarudza sarudzo Value field options (Value Field Settings);
- Pa Advanced tabo mashandiro (Summarise Values By) sarudza oparesheni Sum (Sm);
- Click pano OK.
Ita shuwa kuti yakasarudzwa chiyero inoenderana nehuwandu hwemasero anofanirwa kushandiswa kugadzira iyo PivotTable. Pano iwe unogona zvakare kutsanangura kuti tafura yepivot yakagadzirwa inofanira kuiswa kupi. Unogona kusarudza pepa riripo kuti uise tafura yepivot pairi, kana sarudzo - Kubepa idzva (New worksheet). tinya OK.
Iyo PivotTable ichave yakazara nekutengesa kwekutengesa kune yega yega mutengesi, sezvakaratidzwa mumufananidzo uri pamusoro.
Kana iwe uchida kuratidza mavhoriyamu ekutengesa muzvikamu zvemari, unofanirwa kufomatidza maseru ane izvi zvakakosha. Nzira iri nyore yekuita izvi ndeyekusimbisa maseru ane fomati yaunoda kugadzirisa uye sarudza iyo fomati Mari (Mari) chikamu nhamba (Nhamba) tab Home (Kumba) Excel menyu ribhoni (sezvinoratidzwa pazasi).
Nekuda kweizvozvo, iyo pivot tafura ichaita seizvi:
- pivot tafura isati yaiswa nhamba yemafomati
- pivot tafura mushure mekugadzirisa currency format
Ndokumbira utarise kuti iyo default currency fomati inotsamira pane system marongero.
Inokurudzirwa PivotTables muMavhezheni Azvino eExcel
Mushanduro dzichangoburwa dzeExcel (Excel 2013 kana gare gare), pane Insert (Insert) bhatani riripo Inokurudzirwa matafura epivot (Yakakurudzirwa Pivot Tables). Zvichienderana nedata rakasarudzwa, chishandiso ichi chinopa mafomati etafura yepivot. Mienzaniso inogona kutariswa pawebhusaiti yeMicrosoft Office.