Qaybtan casharrada waxay faahfaahinaysaa sida loo abuuro PivotTable gudaha Excel. Maqaalkan waxaa loo qoray Excel 2007 (iyo sidoo kale noocyadii dambe). Tilmaamaha noocyadii hore ee Excel waxaa laga heli karaa maqaal gaar ah: Sida loo abuuro PivotTable gudaha Excel 2003?
Tusaale ahaan, tixgeli shaxdan soo socota, oo ka kooban xogta iibka ee shirkadda rubuci hore ee 2016:
| 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 | ... | ... | ... | ... | ... |
Si aan u bilowno, aan abuurno miis pivot aad u fudud oo muujin doona wadarta iibka mid kasta oo ka mid ah iibiyeyaasha sida ku cad shaxda kore. Si tan loo sameeyo, samee waxyaabaha soo socda:
- Ka dooro unug kasta oo kala duwan xogta ama tirada oo dhan si loogu isticmaalo miiska pivot.TAXADIR: Haddii aad ka doorato hal unug oo kala duwan xogta, Excel si toos ah ayuu u ogaan doonaa oo u dooran doonaa dhammaan xogta kala duwan ee PivotTable. Si Excel uu u doorto kala duwanaansho sax ah, shuruudaha soo socda waa in la buuxiyaa:
- Tiir kasta oo ka mid ah tirada xogta waa inuu lahaadaa magac u gaar ah;
- Xogtu waa inaysan ku jirin khadadka madhan.
- Gujinaya badhanka shaxda kooban (Pivot Table) ee qaybta Shaxan (Tables) tab insert ( Geli) Xarfaha menu ee Excel.
- Sanduuqa wada hadalka ayaa ka soo muuqan doona shaashadda. Abuur PivotTable (Abuur PivotTable) sida ka muuqata sawirka hoose.
Hubi in kala duwanaanta la doortay ay la mid tahay tirada unugyada ee loo isticmaali karo si loo abuuro PivotTable. Halkan waxa kale oo aad ku qeexi kartaa meesha la geliyo miiska pivot-ka la abuuray. Waxaad dooran kartaa xaashi jira si aad u geliso miiska pivot du, ama ikhtiyaar - Ku socota xaashi cusub (Waraaq shaqo oo cusub). guji OK. - Miiska pivot madhan ayaa soo muuqan doona, iyo sidoo kale guddi Goobaha miiska pivot (Liiska Goobta Pivot) oo leh meelo badan oo xog ah. Ogsoonow in kuwani yihiin madaxyada xaashida xogta asalka ah.
- Dabaqyada Goobaha miiska pivot (Liiska Goobta Pivot):
- jiididda iyo dhibic Wakiilka Iibka deegaanka Saf (Calaamadaha safka);
- jiididda iyo dhibic Lacagta в Qiimaha (Qiimaha);
- Waxaan hubineynaa: in Qiimaha (Qiimaha) waa inay noqdaan qiime Qadarka goobta qaddarka (Isugeynta Qadarka), а не Qadarka goobta inta (Tirada Qadarka).
Tusaalahan, tiirka Lacagta wuxuu ka kooban yahay qiimayaal tirooyin ah, sidaas darteed aagga Σ Qiimaha (Σ Qiimaha) waxaa lagu dooran doonaa si toos ah Qadarka goobta qaddarka (Wadarta tirada). Hadday ku jirto tiir Lacagta wuxuu ka koobnaan doonaa qiimayaal aan tiro ahayn ama madhan, ka dib miiska pivot-ka caadiga ah waa la dooran karaa Qadarka goobta inta (Tirada Qadarka). Haddii tani dhacdo, markaa waxaad u beddeli kartaa tirada qaddarka sida soo socota:
- In ka Σ Qiimaha (Σ Qiimaha) guji Qadarka goobta inta (Tirinta Qadarka) oo dooro ikhtiyaarka Doorashada goobta qiimaha (Dejinta Goobta Qiimaha);
- On the Advanced tab Operation (Qiimaha oo kooban by) dooro qalliin Sum (Sum);
- Riix halkan OK.
Hubi in kala duwanaanta la doortay ay la mid tahay tirada unugyada ee loo isticmaali karo si loo abuuro PivotTable. Halkan waxa kale oo aad ku qeexi kartaa meesha la geliyo miiska pivot-ka la abuuray. Waxaad dooran kartaa xaashi jira si aad u geliso miiska pivot du, ama ikhtiyaar - Ku socota xaashi cusub (Waraaq shaqo oo cusub). guji OK.
PivotTable-ka waxaa ku buuxsami doona wadarta iibka iibiye kasta, sida ka muuqata sawirka kore.
Haddii aad rabto inaad ku muujiso qiimaha iibka ee cutubyada lacagta, waa inaad qaabaysaa unugyada ka kooban qiyamkan. Habka ugu fudud ee tan loo samayn karo waa in la muujiyo unugyada aad rabto in aad habaynayso oo aad doorato qaabka Lacag (Lacagta) qaybta Number (Lambarka) tab Bogga Hore (Guriga) Xarfaha menu ee Excel (sida hoos ku cad).
Natiijo ahaan, miiska pivot wuxuu u ekaan doonaa sidan:
- miiska pivot ka hor dejinta qaabka tirada
- miiska pivot ka dib dejinta qaabka lacagta
Fadlan ogow in qaabka lacagta caadiga ahi ay ku xidhan tahay habaynta nidaamka.
Talooyinka PivotTables ee Noocyadii ugu dambeeyay ee Excel
Noocyadii ugu dambeeyay ee Excel (Excel 2013 ama ka dib), ee ku yaal insert ( Geli ) badhanka jooga Miisaska pivot ee lagu taliyay (Miisaska Pivot ee lagu taliyay). Iyada oo ku saleysan xogta isha la doortay, qalabkani wuxuu soo jeedinayaa qaababka miiska pivot ee suurtogalka ah. Tusaalooyinka waxaa laga eegi karaa mareegaha Microsoft Office.