Bari mu ce muna da ginin pivot tebur tare da sakamakon nazarin tallace-tallace ta watanni don birane daban-daban (idan ya cancanta, karanta wannan labarin don fahimtar yadda ake ƙirƙirar su gabaɗaya ko sabunta ƙwaƙwalwar ajiyar ku):
Muna so mu ɗan canza kamannin sa don ya nuna bayanan da kuke buƙata sosai, ba kawai zubar da tarin lambobi akan allon ba. Me za a iya yi don wannan?
Sauran ayyukan lissafin maimakon adadin banal
Idan ka danna dama akan filin da aka ƙididdige a cikin yankin bayanai kuma zaɓi umarni daga menu na mahallin Zaɓuɓɓukan filin (Saitunan Filin) ko a cikin sigar Excel 2007 - Zaɓuɓɓukan filin darajar (Saitunan Filin Ƙimar), to, taga mai amfani sosai zai buɗe, ta amfani da abin da zaku iya saita gungun saitunan masu ban sha'awa:
Musamman, zaku iya canza aikin lissafin filin cikin sauƙi zuwa ma'ana, ƙarami, matsakaicin, da sauransu. Misali, idan muka canza jimlar zuwa adadi a cikin tebur ɗin pivot ɗinmu, to ba za mu ga jimlar kudaden shiga ba, amma adadin ma'amaloli. ga kowane samfurin:
Ta hanyar tsoho, Excel koyaushe yana zaɓar taƙaitaccen bayanan ƙididdiga ta atomatik. (Sum), kuma ga waɗanda ba ƙididdiga ba (ko da a cikin dubunnan sel masu lambobi akwai aƙalla ɗaya mara komai ko tare da rubutu ko tare da lamba a cikin tsarin rubutu) - aiki don kirga adadin ƙimar. (ƙidaya).
Idan kana so ka gani a cikin tebur pivot daya lokaci daya matsakaici, adadin, da yawa, watau ayyuka da yawa na lissafin don filin guda, to, jin kyauta don jefa linzamin kwamfuta a cikin bayanan filin da kake buƙatar sau da yawa. a jere don samun wani abu makamancin haka:
... sannan saita ayyuka daban-daban don kowane filin ta danna su bi da bi tare da linzamin kwamfuta da zabar umarni Zaɓuɓɓukan filin (Saitunan filin)don gamawa da abin da kuke so:
Idan a cikin taga guda Zaɓuɓɓukan filin danna maballin Ƙari (Zaɓuɓɓuka) ko kuma zuwa shafin Ƙarin Lissafi (a cikin Excel 2007-2010), sa'an nan jerin zaɓuka zai zama samuwa Ƙarin Lissafi (Nuna bayanai kamar):
A cikin wannan jeri, alal misali, zaku iya zaɓar zaɓuɓɓuka Kashi na adadin layin (% na jere), Kashi na jimla ta shafi (% na shafi) or Raba duka (% na duka)don lissafta kaso ta atomatik ga kowane samfur ko birni. Wannan shine yadda, alal misali, tebur ɗin mu zai yi kama da aikin da aka kunna Kashi na jimla ta shafi:
Hanyoyin tallace-tallace
Idan a cikin jerin saukewa Ƙarin Lissafi (Nuna bayanai kamar) zaɓi zaɓi Bambanci (Bambanci), kuma a cikin ƙananan windows Field (Filin tushe) и Sinadarin (Base abu) zaži Watan и Back (a cikin harshen Ingilishi na asali, maimakon wannan baƙon kalmar, akwai ƙarin fahimta A baya, wadanda. na baya):
... sannan mu sami tebur mai mahimmanci wanda ke nuna bambance-bambancen tallace-tallace na kowane wata mai zuwa daga wanda ya gabata, watau - yanayin tallace-tallace:
Kuma idan kun canza Bambanci (Bambanci) on Bambanci (% na bambanci) kuma kara Tsarin yanayi don haskaka dabi'u mara kyau a cikin ja, muna samun abu iri ɗaya, amma ba a cikin rubles ba, amma a matsayin kashi:
PS
A cikin Microsoft Excel 2010, duk saitunan lissafin da ke sama za a iya yin su cikin sauƙi - ta danna dama akan kowane filin da zaɓar umarni daga menu na mahallin. Jimlar don (Taƙaita Ƙimar Ta):
… Da Ƙarin Lissafi (Nuna bayanai kamar):
Hakanan a cikin sigar Excel 2010, an ƙara sabbin ayyuka da yawa zuwa wannan saitin:
- % na jimlar ta jeri na iyaye (column) - yana ba ku damar ƙididdige rabon dangi ga jumhuriyar jimla don jere ko shafi:
A cikin sigar da ta gabata, zaku iya ƙididdige ma'auni kawai dangane da jimillar jimillar.
- % na yawan adadin - yana aiki daidai da aikin jimla, amma yana nuna sakamako azaman juzu'i, watau cikin kashi dari. Ya dace don ƙididdigewa, alal misali, adadin shirin ko aiwatar da kasafin kuɗi:
- Ana rarrabewa daga ƙarami zuwa babba kuma akasin haka - wani baƙon suna don aikin martaba (RANK), wanda ke ƙididdige adadin ma'auni (matsayi) na wani kashi a cikin jerin ƙimar gaba ɗaya. Misali, tare da taimakon sa ya dace don ba da matsayi ga manajoji ta hanyar jimlar kudaden shiga, ƙayyade wanda ke cikin wane wuri a cikin gabaɗayan matsayi:
- 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