Lokacin aiki tare da manyan allunan pivot, sau da yawa dole ne a sauƙaƙe su da ƙarfi, tare da tace wasu bayanan don kada a nutse cikin lambobi. Hanya mafi sauƙi don yin wannan ita ce sanya wasu filaye a cikin wurin tacewa (a cikin sigogin kafin 2007 ana kiran shi yankin shafi) kuma zaɓi kawai mahimman dabi'u daga jerin abubuwan da aka saukar:
Rashin amfanin wannan hanyar a bayyane yake:
- Lokacin da aka zaɓi abubuwa da yawa, ba a bayyane suke, amma rubutun “(abu da yawa)” yana bayyane. Kada mai amfani da abokantaka.
- Tace rahoto ɗaya yana da ƙarfi zuwa tebur pivot ɗaya. Idan muna da tebur pivot da yawa (kuma yawanci al'amarin ba'a iyakance ga ɗaya ba), to kowane (!) Dole ne ku ƙirƙiri naku tacewa kuma kowane ɗayan dole ne ku buɗe shi, danna abubuwan da ake buƙata kuma latsawa. OK. Babban rashin jin daɗi, har ma na ga masu sha'awar da suka rubuta macro na musamman don wannan dalili.
Idan kuna da Excel 2010, to duk wannan ana iya yin shi da kyau - ta amfani da shi yanka (yanka). yanka shine madaidaicin maɓalli mai hoto mai maɓalli na masu tace rahoton m don PivotTable ko Chart:
Yanke yana kama da wani abu mai hoto daban (kamar ginshiƙi ko hoto), ba'a haɗa shi da sel, kuma ana nunawa sama da takardar, wanda ke sauƙaƙa motsa shi. Don ƙirƙirar slicer don tebur pivot na yanzu, je zuwa shafin Siga (Zaɓuɓɓuka) kuma a cikin rukuni Tace sannan tace (Kira da tace) danna maballin Manna Yanki (Saka slicer):
Yanzu, lokacin zabar ko zabar abubuwan slicer (zaku iya amfani da maɓallan Ctrl и Motsi, da kuma swiping tare da maɓallin linzamin kwamfuta na hagu da aka danna don zaɓar cikin girma) tebur pivot zai nuna bayanan da aka tace kawai don abubuwan da aka zaɓa. Ƙarin kyakkyawan nuance shi ne cewa yanki a cikin launuka daban-daban yana nuna ba kawai zaɓin da aka zaɓa ba, har ma da abubuwa marasa komai waɗanda babu ƙima ɗaya a cikin teburin tushe:
Idan kun yi amfani da slicers da yawa, wannan zai ba ku damar nuna alaƙa tsakanin abubuwan bayanai cikin sauri da gani:
Ana iya haɗa slicer iri ɗaya cikin sauƙi zuwa yawancin PivotTables da PivotCharts ta amfani da Siga (Zaɓuɓɓuka) button Haɗin PivotTable (Haɗin tebur na Pivot)wanda ke buɗe akwatin maganganu masu dacewa:
Sa'an nan zaɓin abubuwa a kan yanki ɗaya zai shafi tebur da zane-zane da yawa a lokaci ɗaya, watakila ma a kan zanen gado daban-daban.
Hakanan ba a manta da bangaren zane ba. Don tsara slicers akan shafi Constructor (Zane) Akwai salon layi da yawa:
...da ikon ƙirƙirar zaɓuɓɓukan ƙirar ku:
Kuma a cikin haɗin "pivot table - pivot chart - yanki", duk wannan yana da ban mamaki sosai:
- Menene allunan pivot da yadda ake gina su
- Ƙirƙiri lambobi da kwanan wata tare da matakin da ake so a cikin allunan pivot
- Gina Rahoton PivotTable akan Maɗaukakin Bayanan Bayanai
- Saita lissafi a cikin PivotTables