Tiyeni tiyambe ndi funso lodziwika kwambiri:Kodi tebulo la pivot mu Excel ndi chiyani?«
Pivot Tables mu Excel thandizani kufotokoza mwachidule deta yochuluka mu tebulo lofananizira. Izi zikufotokozedwa bwino ndi chitsanzo.
Tiyerekeze kuti kampani yasunga tebulo la malonda opangidwa m'gawo loyamba la 2016. Gome ili ndi deta: tsiku logulitsa (Date), nambala ya invoice (Invoice Ref), mtengo wa invoice (kuchuluka), dzina la wogulitsa (Sales Rep.) ndi malo ogulitsa (Chigawo). Tebulo ili likuwoneka motere:
A | B | C | D | E | |
---|---|---|---|---|---|
1 | Date | Invoice Ref | kuchuluka | Sales Rep. | Chigawo |
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 | ... | ... | ... | ... | ... |
Gome la pivot mu Excel limatha kufotokozera mwachidule zomwe zaperekedwa patebulo lomwe laperekedwa, kuwonetsa kuchuluka kwa zolembedwa kapena kuchuluka kwa zikhalidwe zomwe zili mugawo lililonse. Mwachitsanzo, tebulo la pivot ili likuwonetsa malonda onse a onse ogulitsa anayi mgawo loyamba la 2016:
Pansipa pali tebulo la pivot lovuta kwambiri. Pa tebulo ili, ndalama zogulitsa za wogulitsa aliyense zimagawidwa pamwezi:
Ubwino wina wa Excel PivotTables ndikuti atha kugwiritsidwa ntchito kuchotsa mwachangu deta kuchokera pagawo lililonse la tebulo. Mwachitsanzo, ngati mukufuna kuwona mndandanda wamalonda wa ogulitsa ndi dzina lomaliza Brown Januware 2016 (Jan), dinani kawiri pa selo lomwe likuyimira mtengo (patebulo pamwambapa, mtengo uwu $ 28,741)
Izi zipanga tebulo latsopano mu Excel (monga momwe tawonetsera pansipa) lomwe limalemba onse ogulitsa ndi dzina lomaliza. Brown kwa Januware 2016.
Pakadali pano, sitikulankhula za momwe matebulo a pivot omwe awonetsedwa pamwambapa adapangidwira. Cholinga chachikulu cha gawo loyamba la phunziroli ndikuyankha funso: "Kodi tebulo la pivot mu Excel ndi chiyani?“. M’mbali zotsatirazi za phunziroli, tiphunzira mmene tingapangire matebulo oterowo.★
★ Werengani zambiri za ma pivot tables: → Pivot tables mu Excel - phunziro