Bari mu fara da mafi yawan tambaya:Menene tebur pivot a cikin Excel?«
Pivot Tables a cikin Excel taimako don taƙaita ɗimbin bayanai a cikin tebur mai kwatanta. An fi bayyana wannan tare da misali.
A ce kamfani ya kiyaye tebur na tallace-tallace da aka yi a farkon kwata na 2016. Tebur ya ƙunshi bayanai: kwanan wata sayarwa (Rana), lambar daftari (Invoice Ref), adadin daftari (Adadin), sunan mai siyarwa (Wakilin tallace-tallace) da kuma yankin tallace-tallace (Region). Wannan teburi yayi kama da haka:
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Rana | Invoice Ref | Adadin | Wakilin tallace-tallace | Region |
| 2 | 01/01/2016 | 2016 - 0001 | $ 819 | Barnes | North |
| 3 | 01/01/2016 | 2016 - 0002 | $ 456 | Brown | South |
| 4 | 01/01/2016 | 2016 - 0003 | $ 538 | Jones | South |
| 5 | 01/01/2016 | 2016 - 0004 | $ 1,009 | Barnes | North |
| 6 | 01/02/2016 | 2016 - 0005 | $ 486 | Jones | South |
| 7 | 01/02/2016 | 2016 - 0006 | $ 948 | Smith | North |
| 8 | 01/02/2016 | 2016 - 0007 | $ 740 | Barnes | North |
| 9 | 01/03/2016 | 2016 - 0008 | $ 543 | Smith | North |
| 10 | 01/03/2016 | 2016 - 0009 | $ 820 | Brown | South |
| 11 | ... | ... | ... | ... | ... |
Tebur mai pivot a cikin Excel na iya taƙaita bayanan da aka gabatar a cikin tebur da aka bayar, nuna adadin bayanai ko jimlar ƙima a kowane shafi. Misali, wannan tebur pivot yana nuna jimlar tallace-tallace na kowane ɗayan masu siyarwa huɗu na kwata na farko na 2016:
A ƙasa akwai ƙarin hadadden tebur pivot. A cikin wannan tebur, jimlar tallace-tallace na kowane mai siyarwa ana rugujewa wata-wata:
Wani fa'idar Excel PivotTables shine cewa ana iya amfani da su don fitar da bayanai da sauri daga kowane bangare na tebur. Misali, idan kuna son ganin jerin tallace-tallace na mai siyarwa da sunan ƙarshe Brown Janairu 2016 (Jan), kawai danna sau biyu akan tantanin halitta wanda ke wakiltar wannan ƙimar (a cikin teburin da ke sama, wannan ƙimar $ 28,741)
Wannan zai haifar da sabon tebur a cikin Excel (kamar yadda aka nuna a ƙasa) wanda ke jera duk tallace-tallace na mai siyarwa da sunan ƙarshe. Brown don Janairu 2016.
A yanzu, ba muna magana ne game da yadda aka ƙirƙiri allunan pivot da aka nuna a sama ba. Babban makasudin sashin farko na koyawa shine amsa tambayar: “Menene tebur pivot a cikin Excel?“. A cikin wadannan sassa na koyawa, za mu koyi yadda ake ƙirƙirar irin waɗannan tebur.★
★ Kara karantawa game da allunan pivot: → Pivot Tables a cikin Excel - koyawa