Ngatiti isu tine yakavakirwa pivot tafura ine mhedzisiro yekuongorora kutengesa nemwedzi kumaguta akasiyana (kana zvichidikanwa, verenga chinyorwa ichi kuti unzwisise maitiro ekuzvigadzira zvakazara kana kuzorodza ndangariro yako):
Isu tinoda kushandura zvishoma chitarisiko chayo kuti iratidze iyo data yaunoda zvakajeka, uye kwete kungorasa boka renhamba pachiratidziri. Chii chingaitwa nokuda kweizvi?
Mamwe mabasa ekuverenga panzvimbo peiyo banal mari
Kana iwe ukadzvanya-kurudyi pane yakaverengerwa ndima munzvimbo yedata uye sarudza murairo kubva pane yemukati menyu Munda Sarudzo (Field Settings) kana muExcel 2007 vhezheni - Value field options (Value Field Settings), ipapo hwindo rinobatsira rinovhurika, uchishandisa iyo iwe yaunogona kuseta boka rezvirongwa zvinonakidza:
Kunyanya, unogona kushandura zviri nyore basa rekuverenga munda kuti ureve, hushoma, huwandu, zvichingodaro. Semuenzaniso, kana tikachinja huwandu hwehuwandu huri mutafura yedu yepivot, isu tichaona kwete iyo yakazara mari, asi nhamba yekutengeserana. kune chimwe nechimwe chigadzirwa:
Nekusagadzikana, Excel inogara ichisarudza otomatiki kupfupisa kwenhamba data. (Sm), uye kune dzisiri dzenhamba (kunyangwe pazviuru zvemasero ane nhamba pane imwe chete isina chinhu kana ine mavara kana ine nhamba mune zvinyorwa zvinyorwa) - basa rekuverenga nhamba yezvikoshi. (Verenga).
Kana iwe uchida kuona mune imwe pivot tafura kamwechete avhareji, huwandu, uye huwandu, kureva akati wandei mabasa ekuverenga emunda mumwe chete, saka inzwa wakasununguka kukanda mbeva munzvimbo yedata yemunda yaunoda kakawanda. mumutsara kuti uwane chimwe chinhu chakafanana:
... uye wobva waisa mabasa akasiyana kune imwe neimwe yeminda nekudzvanya paari negonzo nekusarudza rairo Munda Sarudzo (Zvirongwa zvemumunda)kuti upedze zvaunoda:
Kana muhwindo rimwechete Munda Sarudzo tinya bhatani Kuwedzerwa (Sarudzo) kana kuenda kune tab Kuwedzera Masvomhu (muExcel 2007-2010), ipapo rondedzero yekudonhedza ichave iripo Kuwedzera Masvomhu (Ratidza data se):
Mune iyi runyorwa, semuenzaniso, unogona kusarudza sarudzo Chikamu chemari yemutsetse (% yemutsara), Percentage yehuwandu ne column (% yechikamu) or Chikamu chezvose (% yezvose)kuti uverenge otomatiki zvikamu zvechigadzirwa chimwe nechimwe kana guta. Aya ndiwo maitiro, semuenzaniso, yedu pivot tafura ichaita senge ine basa rakagoneswa Percentage yehuwandu ne column:
Sales dynamics
Kana mune yekudonha pasi list Kuwedzera Masvomhu (Ratidza data se) sarudza sarudzo Kusiyanisa (Musiyano), uye mumahwindo ezasi munda (Base field) и eremendi (Base chinhu) sarudza Mwedzi и shure (mushanduro yechiRungu, panzvimbo peichi izwi rechienzi, pakanga paine zvinonzwisisika Zvakapfuura, avo. yapfuura):
... tobva tawana tafura yepivot inoratidza kusiyana kwekutengesa kwemwedzi wega wega unotevera kubva kune yapfuura, kureva - kutengesa dynamics:
Uye kana ukatsiva Kusiyanisa (Musiyano) on Kupihwa musiyano (% yemusiyano) uye wedzera conditional formatting kuratidza maitiro asina kunaka mutsvuku, tinowana chinhu chimwe chete, asi kwete muRubles, asi sechikamu:
PS
MuMicrosoft Excel 2010, ese ari pamusoro ekuverenga marongero anogona kuitwa kunyange nyore - nekudzvanya-kurudyi pane chero munda uye kusarudza mirairo kubva pane yemukati menyu. Totals for (Sumesa Hunhu Ne):
… Uye Kuwedzera Masvomhu (Ratidza Data se):
Zvakare mushanduro yeExcel 2010, akati wandei mabasa akawedzerwa kune iyi seti:
- % yehuwandu nemutsara wemubereki (koramu) - inokutendera kuti uverenge mugove unoenderana neiyo subtotal yemutsara kana koramu:
Mushanduro dzakapfuura, waingokwanisa kuverenga chikamu chinoenderana nehukuru hwakazara.
- % yemari yakawedzerwa - inoshanda zvakafanana kune cumulative sum function, asi inoratidza mhedzisiro sechidimbu, kureva muzvikamu. Zviri nyore kuverenga, semuenzaniso, chikamu chechirongwa kana bhajeti rekuita:
- Kuronga kubva padiki kusvika pahombe uye neimwe nzira -zita risinganzwisisike zvishoma renzvimbo yebasa (RANK), iyo inoverengera nhamba yeordinal (nzvimbo) yechinhu mune yakajairika runyorwa rwezvakakosha. Semuenzaniso, nerubatsiro rwayo zviri nyore kuisa maneja nemari yavo yese, kuona kuti ndiani ari munzvimbo ipi mune yese kumira:
- Chii chinonzi pivot matafura uye magadzirirwo awo
- Kuisa nhamba nemazuva nedanho rinodiwa mumatafura epivot
- Kuvaka Chirevo chePivotTable pane Akawanda Ranges eMabviro Data