E hoʻomaka kākou me ka nīnau maʻamau:He aha ka papa pivot ma Excel?«
Nā Papa Pivot ma Excel kōkua i ka hōʻuluʻulu ʻana i ka nui o nā ʻikepili i loko o kahi papa hoʻohālikelike. Ua wehewehe maikaʻi ʻia kēia me kahi laʻana.
Inā paha ua mālama kahi hui i kahi papa o nā kūʻai i hana ʻia i ka hapaha mua o 2016. Aia ka papa i ka ʻikepili: lā kūʻai (lā), helu helu (Invoice Ref), ka huina kālā (huina), inoa mea kūʻai (Sales Rep.) a me ka ʻāina kūʻai (Māhele). Penei ke ano o keia papa:
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | lā | Invoice Ref | huina | Sales Rep. | Māhele |
| 2 | 01/01/2016 | 2016 - 0001 | $ 819 | Barnes | Ke akau |
| 3 | 01/01/2016 | 2016 - 0002 | $ 456 | Palaunu | Ka hema |
| 4 | 01/01/2016 | 2016 - 0003 | $ 538 | Jones | Ka hema |
| 5 | 01/01/2016 | 2016 - 0004 | $ 1,009 | Barnes | Ke akau |
| 6 | 01/02/2016 | 2016 - 0005 | $ 486 | Jones | Ka hema |
| 7 | 01/02/2016 | 2016 - 0006 | $ 948 | Smith | Ke akau |
| 8 | 01/02/2016 | 2016 - 0007 | $ 740 | Barnes | Ke akau |
| 9 | 01/03/2016 | 2016 - 0008 | $ 543 | Smith | Ke akau |
| 10 | 01/03/2016 | 2016 - 0009 | $ 820 | Palaunu | Ka hema |
| 11 | ... | ... | ... | ... | ... |
Hiki i kahi papa pivot ma Excel ke hōʻuluʻulu i ka ʻikepili i hōʻike ʻia ma kahi papa i hāʻawi ʻia, e hōʻike i ka helu o nā moʻolelo a i ʻole ka huina o nā waiwai i kekahi kolamu. No ka laʻana, hōʻike kēia papa pivot i ka huina kūʻai o kēlā me kēia o nā mea kūʻai aku ʻehā no ka hapaha mua o 2016:
Aia ma lalo kahi papa pivot paʻakikī. Ma kēia pākaukau, hoʻokaʻawale ʻia nā huina kūʻai o kēlā me kēia mea kūʻai aku ma ka mahina:
ʻO kekahi pōmaikaʻi ʻē aʻe o Excel PivotTables ʻo ia ka hiki ke hoʻohana ʻia e unuhi koke i ka ʻikepili mai kekahi ʻāpana o ka papaʻaina. No ka laʻana, inā makemake ʻoe e ʻike i kahi papa inoa kūʻai aku o ka mea kūʻai aku ma ka inoa hope Palaunu Ianuali 2016 (Jan), kaomi pālua wale i ke kelepona e hōʻike ana i kēia waiwai (ma ka papa ma luna, kēia waiwai $ 28,741)
E hana ana kēia i papaʻaina hou ma Excel (e like me ka mea i hōʻike ʻia ma lalo nei) e papa inoa i nā kūʻai āpau a ka mea kūʻai aku ma ka inoa hope. Palaunu no Ianuali 2016.
I kēia manawa, ʻaʻole mākou e kamaʻilio e pili ana i ka hana ʻana o nā papa pivot i hōʻike ʻia ma luna. ʻO ka pahuhopu nui o ka hapa mua o ke aʻo ʻana e pane i ka nīnau: "He aha ka papa pivot ma Excel?“. Ma nā ʻāpana o ke aʻo ʻana, e aʻo mākou i ka hana ʻana i ia mau papa.★
★ Heluhelu hou aʻe e pili ana i nā papa pivot: → Nā papa pivot ma Excel – kumu aʻo