Uma usebenza ngamathebula e-pivot amakhulu, uvamise ukuwenza abe lula, uhlunge olunye ulwazi ukuze ungaminzi ngezinombolo. Indlela elula yokwenza lokhu ukubeka ezinye izinkambu endaweni yokuhlunga (ezinguqulweni zangaphambi kuka-2007 yayibizwa ngokuthi indawo yekhasi) bese ukhetha amanani adingekayo kuphela ohlwini lokudonsela phansi:
Ububi bale ndlela busobala:
- Uma izinto eziningi zikhethiwe, azibonakali, kodwa umbhalo othi “(izinto eziningi)” uyabonakala. Ayisebenziseki kalula.
- Isihlungi sombiko esisodwa sifakwe ngokuqinile kuthebula le-pivot elilodwa. Uma sinamathebula e-pivot amaningana (futhi ngokuvamile udaba alukhawulelwe kwelilodwa), kuzomele (!) uzenzele esakho isihlungi futhi kulelo nalelo uzolivula, phawula izakhi ezidingekayo bese ucindezela. OK. Okubi kakhulu, ngaze ngabona abathanda ukubhala amamakhro akhethekile ngale njongo.
Uma une-Excel 2010, konke lokhu kungenziwa ngomusa kakhudlwana - usebenzisa tincetu (izisiki). tincetu iyinkinobho ebonisa isithombe esikahle sezihlungi ezisebenzayo ze-PivotTable noma Ishadi:
Isisiki sibukeka njengesithombe esihlukile (njengeshadi noma isithombe), asihlotshaniswa namaseli, futhi siboniswa ngaphezu kweshidi, okwenza kube lula ukulihambisa. Ukuze udale isisiki sethebula le-pivot lamanje, hamba kuthebhu Amapharamitha (Izinketho) naseqenjini Hlunga bese uhlunga (Hlunga bese uhlunga) chofoza inkinobho Namathisela Ucezu (Faka isisiki):
Manje, lapho ukhetha noma uyeka ukukhetha ama-elementi esisiki (ungasebenzisa okhiye Ctrl и Shift, kanye nokuswayipha ngenkinobho yegundane engakwesokunxele ecindezelwe ukuze ukhethe ngobuningi) ithebula le-pivot lizobonisa kuphela idatha ehlungiwe yezinto ezikhethiwe. Enye i-nuance enhle eyengeziwe ukuthi ucezu olunemibala ehlukene alubonisi nje kuphela okukhethiwe, kodwa futhi nezinto ezingenalutho ezingenalo inani elilodwa kuthebula lomthombo:
Uma usebenzisa izisiki eziningi, lokhu kuzokuvumela ukuthi ubonise ngokushesha nangokubukeka ubudlelwano phakathi kwama-elementi edatha:
Isisiki esifanayo singaxhunywa kalula kuma-PivotTables amaningi kanye nama-PivotCharts kusetshenziswa i Amapharamitha (Izinketho) inkinobho Ukuxhumeka kwePivotTable (Ukuxhumana kwethebula le-Pivot)okuvula ibhokisi lengxoxo elihambisanayo:
Khona-ke ukukhethwa kwezakhi kucezu olulodwa kuzothinta amatafula amaningana kanye nemidwebo ngesikhathi esisodwa, mhlawumbe ngisho nasemashidini ahlukene.
Ingxenye yokuklama nayo ayikhohlwanga. Ukufometha izisiki kuthebhu umakhi (Umklamo) Kunezitayela ezimbalwa zomugqa:
…kanye nekhono lokuzenzela ezakho izinketho zokuklama:
Futhi kunhlanganisela "yethebula le-pivot - ishadi le-pivot - slice", konke lokhu kubukeka kumangalisa kakhulu:
- Ayini amathebula e-pivot nokuthi akhiwa kanjani
- Ukuqoqa izinombolo namadethi ngesinyathelo esifunekayo kumathebula e-pivot
- Ukwakha Umbiko Wethebula Le-Pivot Kububanzi Obuningi Bedatha Yomthombo
- Setha izibalo ku-PivotTables