Tiyerekeze kuti tili ndi tebulo la pivot lopangidwa ndi zotsatira za kusanthula malonda ndi miyezi ya mizinda yosiyanasiyana (ngati kuli kofunikira, werengani nkhaniyi kuti mumvetse momwe mungapangire iwo onse kapena kukumbukira kukumbukira kwanu):
Tikufuna kusintha pang'ono mawonekedwe ake kuti awonetse zomwe mukufuna momveka bwino, osati kungotaya mulu wa manambala pazenera. Kodi chingachitike n’chiyani?
Ntchito zina zowerengera m'malo mwa kuchuluka kwa banal
Ngati mudina kumanja pagawo lowerengedwa m'dera la data ndikusankha lamulo kuchokera pamenyu yankhani Zosankha Zam'munda (Zokonda Zam'munda) kapena mu Excel 2007 version - Zosankha zamtengo wapatali (Zikhazikiko za Munda Wamtengo), ndiye zenera lothandiza kwambiri lidzatsegulidwa, lomwe mungagwiritse ntchito kukhazikitsa zokonda zambiri:
Makamaka, mutha kusintha mosavuta ntchito yowerengera kumunda kuti itanthauza, osachepera, pazipita, ndi zina zambiri. Mwachitsanzo, ngati tisintha kuchuluka kwa kuchuluka mu tebulo lathu la pivot, ndiye kuti sitiwona ndalama zonse, koma kuchuluka kwa zochitika. pa chinthu chilichonse:
Mwachikhazikitso, Excel nthawi zonse imasankha mawerengero a manambala. (Chiwerengero), ndi osakhala manambala (ngakhale ngati mwa maselo chikwi okhala ndi manambala pali chimodzi chopanda kanthu kapena chokhala ndi mawu kapena nambala m'mawu olembedwa) - ntchito yowerengera nambala yamtengo wapatali. (Kuwerengera).
Ngati mukufuna kuwona patebulo limodzi la pivot nthawi imodzi pafupifupi, kuchuluka kwake, ndi kuchuluka kwake, mwachitsanzo, mawerengedwe angapo a gawo lomwelo, ndiye omasuka kuponya mbewa m'dera la data lomwe mukufuna kangapo. mumzere kuti mupeze zofanana:
…ndipo ikani ntchito zosiyanasiyana pagawo lililonse podina pawo motsatana ndi mbewa ndikusankha lamulo Zosankha Zam'munda (Zokonda zam'munda)kuti mukwaniritse zomwe mukufuna:
Ngati pawindo lomwelo Zosankha Zam'munda dinani batani Kuwonjezera apo (Zosankha) kapena pitani ku tabu Mawerengedwe Owonjezera (mu Excel 2007-2010), ndiye kuti mndandanda wotsitsa udzapezeka Mawerengedwe Owonjezera (Onetsani data ngati):
Pamndandandawu, mwachitsanzo, mutha kusankha zosankha Peresenti ya kuchuluka kwa mzere (% ya mzere), Maperesenti onse ndi magawo (% ya gawo) or Gawo la zonse (% yonse)kuti muwerengere zokha maperesenti a chinthu chilichonse kapena mzinda uliwonse. Umu ndi momwe, mwachitsanzo, tebulo lathu la pivot lidzawoneka ngati ntchitoyo yayatsidwa Maperesenti onse ndi magawo:
Zogulitsa malonda
Ngati mu dontho pansi mndandanda Mawerengedwe Owonjezera (Onetsani data ngati) sankhani njira Kusiyanitsa (Kusiyana), ndi m'mawindo apansi Field (Base field) и mchitidwe (Chinthu choyambira) sankhani mwezi и Back (m’Chingelezi chobadwa nacho, m’malo mwa mawu achilendowa, panali mawu omveka bwino M'mbuyomu, izo. kale):
...kenako timapeza tebulo la pivot lomwe limasonyeza kusiyana kwa malonda a mwezi uliwonse wamawa ndi wam'mbuyo, mwachitsanzo - malonda a malonda:
Ndipo ngati mutasintha Kusiyanitsa (Kusiyana) on Kupatsidwa kusiyana (% ya kusiyana) ndi kuwonjezera kusanjidwa koyenera kuti tiwonetsere zonyansa zofiira, timapeza zomwezo, koma osati ma ruble, koma peresenti:
PS
Mu Microsoft Excel 2010, zosintha zonse zomwe zili pamwambapa zitha kuchitika mosavuta - podina kumanja pagawo lililonse ndikusankha malamulo kuchokera pazosankha Chiwerengero cha (Chiduleni Makhalidwe Ndi):
… Ndipo Mawerengedwe Owonjezera (Onetsani Deta ngati):
Komanso mu mtundu wa Excel 2010, ntchito zingapo zatsopano zidawonjezedwa pa seti iyi:
- % ya chiwerengero chonse ndi mzere wa makolo (gawo) - imakupatsani mwayi wowerengera gawo lomwe likugawana ndi subtotal pamzere kapena mzere:
M'matembenuzidwe am'mbuyomu, mutha kungowerengera kuchuluka kwa chiwonkhetso chonse.
- % ya kuchuluka kwa ndalama - imagwira ntchito mofanana ndi kuchuluka kwa ntchito, koma imawonetsa zotsatira ngati kachigawo kakang'ono, mwachitsanzo, mu maperesenti. Ndikosavuta kuwerengera, mwachitsanzo, kuchuluka kwa mapulani kapena bajeti:
- Kusanja kuyambira chaching'ono kupita chachikulu ndi mosemphanitsa - dzina lachilendo pang'ono la ntchito ya kusanja (RANK), yomwe imawerengera nambala ya ordinal (malo) a chinthu pamndandanda wazonse. Mwachitsanzo, ndi thandizo lake ndikosavuta kuyika oyang'anira ndi ndalama zawo zonse, kudziwa yemwe ali pamalo onse:
- Kodi ma pivot tables ndi momwe angawapangire
- Kuyika manambala m'magulu ndi madeti ndi sitepe yomwe mukufuna mu pivot tables
- Kupanga Lipoti la PivotTable pamitundu ingapo ya Source Data