Aan ku bilowno su'aasha ugu badan:Waa maxay miiska pivot ee Excel?«
Shaxan Pivot ee Excel Caawinta in lagu soo koobo tiro badan oo xog ah shaxda isbarbardhigga. Tan waxaa sida ugu fiican loogu sharaxay tusaale.
Ka soo qaad in shirkad ay xajisay shaxda iibka ee la sameeyay rubuci hore ee 2016. Shaxda waxa ku jira xog: taariikhda iibka (Taariikhda), lambarka qaansheegta (Qaansheeg Ref), qaddarka qaansheegta (Lacagta), magaca iibiyaha (Wakiilka Iibka) iyo gobolka iibkaGobolka). Shaxdani waxay u egtahay sidan:
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Taariikhda | Qaansheeg Ref | Lacagta | Wakiilka Iibka | Gobolka |
| 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 | ... | ... | ... | ... | ... |
Shaxda pivot ee Excel waxa ay soo koobi kartaa xogta lagu soo bandhigay shax la bixiyay, waxa ay tusi kartaa tirada diiwaanada ama wadarta qiyamka tiir kasta. Tusaale ahaan, shaxdan pivot-ka ah waxay muujinaysaa wadarta iibka mid kasta oo ka mid ah afarta iibiye ee rubuci hore ee 2016:
Hoos waxaa ah miis aad u adag. Jadwalkan, wadarta iibka iibiye kasta waxa loo qaybiyaa bil kasta:
Faa'iidada kale ee Excel PivotTables waa in loo isticmaali karo in si degdeg ah looga soo saaro xogta qayb kasta oo miiska ah. Tusaale ahaan, haddii aad rabto inaad aragto liiska iibka ee iibiyaha ee magaca dambe Brown Janaayo 2016 (Jan), kaliya laba jeer ku dhufo unugga u taagan qiimahan ( shaxda sare, qiimahan $ 28,741)
Tani waxay abuuri doontaa miis cusub oo Excel ah (sida hoos ku cad) kaas oo taxaya dhammaan iibka iibiyaha ee magaca dambe. Brown Janaayo 2016.
Hadda, kama hadlayno sida loo abuuray miisaska pivot-ka ee kor lagu muujiyey. Hadafka ugu weyn ee qaybta hore ee casharrada waa in laga jawaabo su'aasha: "Waa maxay miiska pivot ee Excel?“. Qaybaha soo socda ee casharrada, waxaan ku baran doonaa sida loo sameeyo miisaska noocaan ah.★
★ Akhri wax badan oo ku saabsan miisaska pivot: → Pivot tables in Excel – tutorial