Contents
Pono pinepine e hui i ka papa kuhikuhi ma ka lālani a i ʻole nā poʻomanaʻo kolamu. No nā waiwai helu, hiki iā Excel ke hana maʻalahi (me nā lā a me nā manawa). Hōʻike ʻia kēia ma lalo me nā laʻana.
Laʻana 1: Ka hui ʻana i kahi papa pivot ma ka lā
Inā paha ua hana mākou i PivotTable (e like me ke kiʻi ma lalo) e hōʻike ana i ka ʻikepili kūʻai no kēlā me kēia lā o ka hapaha mua o 2016.
Inā makemake ʻoe e hui pū i ka ʻikepili kūʻai ma ka mahina, hiki iā ʻoe ke hana penei:
- Kaomi ʻākau ma ka ʻaoʻao hema o ka papa pivot (ke kolamu me nā lā) a koho i ke kauoha Group (Puʻupuʻu). E hōʻike ʻia kahi pahu kamaʻilio Ka Hoʻohui (Grouting) no nā lā.
- E koho i malama (Mahina) a kaomi OK. E hui pū ʻia ka ʻikepili papa ma ka mahina e like me ka hōʻike ʻana ma ka papa pivot ma lalo nei.
Laʻana 2: Hoʻouluulu i ka Pivot Table ma ka Laʻana
Inā paha ua hana mākou i PivotTable (e like me ke kiʻi ma lalo) e hui pū i kahi papa inoa o nā keiki 150 ma ka makahiki. Hoʻokaʻawale ʻia nā hui e nā makahiki mai 5 a 16 mau makahiki.
Inā makemake ʻoe e hele i mua a hoʻohui i nā pūʻulu makahiki i nā ʻāpana 5-8 mau makahiki, 9-12 mau makahiki a me 13-16 mau makahiki, a laila hiki iā ʻoe ke hana i kēia:
- Kaomi ʻākau ma ka ʻaoʻao hema o ka papa pivot (ke kolamu me nā makahiki) a koho i ke kauoha Group (Puʻupuʻu). E hōʻike ʻia kahi pahu kamaʻilio Ka Hoʻohui (Ka hui pū ʻana) no nā helu. E hoʻopiha aunoa ʻo Excel i nā kahua No ka (E hoʻomaka ana) и On (E hoʻopau i) me nā helu liʻiliʻi a me ka nui loa mai kā mākou ʻikepili mua (i kā mākou hiʻohiʻona, ʻo ia ka 5 a me 16).
- Makemake mākou e hoʻohui i nā pūʻulu makahiki i nā ʻāpana o 4 mau makahiki, no laila, ma ke kula Me kahi ʻanuʻu (By) komo i ka waiwai 4. Kaomi OK.No laila, e hui pū ʻia nā pūʻulu makahiki i nā ʻāpana e hoʻomaka ana mai 5-8 mau makahiki a laila ma kahi o 4 mau makahiki. ʻO ka hopena he papa e like me kēia:
Pehea e wehe ai i kahi papa pivot
No ka wehe ʻana i nā waiwai ma kahi papa pivot:
- Kaomi ʻākau ma ka ʻaoʻao hema o ka papa pivot (ke kolamu i loaʻa nā waiwai i hui pū ʻia);
- Ma ka papa kuhikuhi i hōʻike ʻia, kaomi Hoʻohui (E wehe i ka hui).
Nā hewa maʻamau i ka hui ʻana i kahi Pivottable
Ua hewa i ka wā e hui pū ai i ka papa pivot: ʻAʻole hiki ke hoʻohui ʻia nā mea i koho ʻia i kahi hui (ʻAʻole hiki ke hui i kēlā koho).
I kekahi manawa ke hoʻāʻo ʻoe e hui i kahi papa pivot, ʻike ʻia ke kauoha Group (Pūʻulu) ʻaʻole hana i ka papa kuhikuhi, a i ʻole e puka mai kahi pahu memo hewa ʻAʻole hiki ke hoʻohui ʻia nā mea i koho ʻia i kahi hui (ʻAʻole hiki ke hui i kēlā koho). Loaʻa pinepine ʻia kēia ma muli o kahi kolamu ʻikepili ma ka papa kumu i loaʻa nā waiwai helu ʻole a i ʻole nā hewa. No ka hoʻoponopono ʻana i kēia, pono ʻoe e hoʻokomo i nā helu a i ʻole nā lā ma kahi o nā waiwai helu ʻole.
A laila kaomi ʻākau ma ka papa pivot a kaomi Hoʻohou a mālama (hōʻano hou). E hōʻano hou ʻia ka ʻikepili ma ka Pivot Table a pono e loaʻa i kēia manawa ka hui ʻana o ka lālani a i ʻole ke kolamu.