Setha izibalo ku-PivotTables

Ake sithi sinethebula le-pivot elakhiwe elinemiphumela yokuhlaziya ukuthengisa ngezinyanga zamadolobha ahlukene (uma kunesidingo, funda lesi sihloko ukuze uqonde ukuthi ungawadala kanjani ngokuvamile noma uvuselele inkumbulo yakho):

Sifuna ukushintsha kancane ukubukeka kwayo ukuze ibonise idatha oyidingayo ngokucacile, futhi ingagcini nje ngokulahla inqwaba yezinombolo esikrinini. Yini engenziwa kulokhu?

Eminye imisebenzi yokubala esikhundleni senani le-banal

Uma uchofoza kwesokudla endaweni ebaliwe endaweni yedatha bese ukhetha umyalo ovela kumenyu yokuqukethwe Izinketho Zenkundla (Izilungiselelo Zenkambu) noma ku-Excel 2007 version - Izinketho zenkambu yenani (Izilungiselelo Zenkundla Yenani), khona-ke iwindi eliwusizo kakhulu lizovuleka, lapho ungasetha khona inqwaba yezilungiselelo ezithakazelisayo:

 Ikakhulukazi, ungakwazi ukushintsha kalula umsebenzi wokubala wenkundla ukuze usho, ubuncane, ubuningi, njll. Isibonelo, uma sishintsha isamba sibe inani elikuthebula lethu le-pivot, ngeke sibone inani lemali engenayo, kodwa inani lemisebenzi. kumkhiqizo ngamunye:

Ngokuzenzakalelayo, i-Excel ihlale ikhetha ngokuzenzakalelayo ukufinyezwa kwedatha yezinombolo. (Isamba), nakulawo angewona amanani (ngisho noma kumaseli ayinkulungwane anezinombolo kukhona okungenani elilodwa elingenalutho noma elinombhalo noma elinenombolo ngefomethi yombhalo) – umsebenzi wokubala inani lamanani (Bala).

Uma ufuna ukubona etafuleni elilodwa le-pivot ngesikhathi esisodwa isilinganiso, inani, kanye nenani, okungukuthi imisebenzi yokubala eminingana yenkambu efanayo, zizwe ukhululekile ukuphonsa igundane endaweni yedatha yenkundla oyidinga izikhathi ezimbalwa. ngokulandelana ukuze uthole okufanayo:

 …bese usetha imisebenzi ehlukene yenkambu ngayinye ngokuchofoza kuzo ngokushintshana ngegundane bese ukhetha umyalo Izinketho Zenkundla (Izilungiselelo zenkambu)ukuze uqedele okufunayo:

ukwabelana ngentshisekelo

Uma efasiteleni elifanayo Izinketho Zenkundla chofoza inkinobho Ukwengeza (Izinketho) noma uye kuthebhu Izibalo ezengeziwe (ku-Excel 2007-2010), bese uhlu lokudonsela phansi luzotholakala Izibalo ezengeziwe (Bonisa idatha njenge):

Kulolu hlu, isibonelo, ungakhetha izinketho Amaphesenti yenani lomugqa (% womugqa), Iphesenti lengqikithi ngekholomu (% yekholomu) or Isabelo sengqikithi (% yenani eliphelele)ukubala ngokuzenzakalelayo amaphesenti omkhiqizo ngamunye noma idolobha. Lena yindlela, isibonelo, ithebula lethu le-pivot elizobukeka ngayo uma umsebenzi usunikwe amandla Iphesenti lengqikithi ngekholomu:

Amandla okuthengisa

Uma esohlwini lokudonsela phansi Izibalo ezengeziwe (Bonisa idatha njenge) khetha inketho Ukuhlukanisa (Umehluko), nasemafasiteleni aphansi Inkambu (Inkambu yesisekelo) и I-Element (Into eyisisekelo) khetha izinyanga и Emuva (enguqulweni yomdabu yesiNgisi, esikhundleni saleli gama eliyinqaba, kwakunokuqondakala kakhudlwana Ngaphambilini, labo. edlule):

…bese sithola ithebula le-pivot elibonisa umehluko ekuthengisweni kwenyanga ngayinye ezayo kusukela kwedlule, okungukuthi – amandla okuthengisa:

Futhi uma esikhundleni Ukuhlukanisa (Umehluko) on Umehluko onikeziwe (% umehluko) bese wengeza ukufometha okunemibandela ukugqamisa amanani amabi ngokubomvu, sithola into efanayo, kodwa hhayi ngama-ruble, kodwa njengephesenti:

PS

Ku-Microsoft Excel 2010, zonke lezi zilungiselelo zokubala ezingenhla zingenziwa kalula - ngokuchofoza kwesokudla kunoma iyiphi inkundla nokukhetha imiyalo kwimenyu yokuqukethwe. Amanani we (Fingqa Amanani Ngu):

Setha izibalo ku-PivotTables

… Futhi Izibalo ezengeziwe (Bonisa Idatha njenge):

Setha izibalo ku-PivotTables

Futhi enguqulweni ye-Excel 2010, imisebenzi eminingana emisha yengezwe kuleli sethi:

  • % yenani eliphelele ngomugqa womzali (ikholomu) - ikuvumela ukubala isabelo esihlobene nesamba esincane somugqa noma ikholomu:

    Ezinguqulweni zangaphambilini, ubungakwazi kuphela ukubala ingxenye ehlobene nengqikithi ephelele.

  • % yenani eliqongelelwe – isebenza ngokufanayo nomsebenzi wesamba esiqongelelwe, kodwa iveza umphumela njengeqhezu, okungukuthi ngamaphesenti. Kulula ukubala, ngokwesibonelo, iphesenti lohlelo noma ukusetshenziswa kwesabelomali:

     

  • Ukuhlunga kusukela kwencane kakhulu kuye kwenkulu futhi ngokuphambene nalokho – igama eliyinqaba kancane lomsebenzi wezinga (RANK), elibala inombolo ye-ordinal (indawo) ye-elementi ohlwini olujwayelekile lwamanani. Isibonelo, ngosizo lwayo kulula ukukala abaphathi ngenani labo lemali engenayo, ukucacisa ukuthi ubani ukuyiphi indawo ekumeni kukonke:

  • Ayini amathebula e-pivot nokuthi akhiwa kanjani
  • Ukuqoqa izinombolo namadethi ngesinyathelo esifunekayo kumathebula e-pivot
  • Ukwakha Umbiko Wethebula Le-Pivot Kububanzi Obuningi Bedatha Yomthombo

 

shiya impendulo