I ka hana ʻana me nā papa pivot nui, pono ʻoe e hoʻomaʻamaʻa ikaika iā lākou, kānana i kekahi o ka ʻike i ʻole e make i nā helu. ʻO ke ala maʻalahi loa e hana i kēia, ʻo ia ke kau ʻana i kekahi mau māla i ka wahi kānana (i nā mana ma mua o 2007 ua kapa ʻia ʻo ia ʻo ka ʻaoʻao ʻaoʻao) a koho wale i nā waiwai pono mai nā papa kuhikuhi iho:
ʻIke ʻia nā hemahema o kēia ʻano:
- Ke koho ʻia nā mea he nui, ʻaʻole ʻike ʻia, akā ʻike ʻia ke kikokikona "(mau mea he nui)". ʻAʻohe mea hoʻohana.
- Hoʻopili ʻia kahi kānana hōʻike i hoʻokahi papa pivot. Inā loaʻa iā mākou nā papa pivot he nui (a ʻaʻole i kaupalena ʻia ka mea i hoʻokahi), a laila no kēlā me kēia (!) Pono ʻoe e hana i kāu kānana ponoʻī a no kēlā me kēia e wehe ʻoe, koho i nā mea pono a kaomi. OK. Maikaʻi loa, ʻike wau i nā mea hoihoi i kākau i nā macros kūikawā no kēia kumu.
Inā loaʻa iā ʻoe ka Excel 2010, a laila hiki ke hana maikaʻi ʻia kēia mau mea āpau - me ka hoʻohana ʻana Paʻi (nā ʻokiʻoki). Paʻi He pihi maʻalahi ka hōʻike kiʻi o nā kānana hōʻike pili no kahi PivotTable a i ʻole Chart:
ʻO ka mea slicer ke ʻano he mea kiʻi ʻokoʻa (e like me ka pakuhi a i ʻole ke kiʻi), ʻaʻole pili me nā cell, a hōʻike ʻia ma luna o ka pepa, e maʻalahi ai ka neʻe ʻana a puni. No ka hana ʻana i kahi slicer no ka papa pivot o kēia manawa, e hele i ka pā kiko'î (Nā koho) a ma kahi hui Hoʻokaʻina a me ka kānana (Hoʻokaʻawale a kānana) kaomi i ke pihi Paʻi ʻāpana (Hoʻokomo i ka mea ʻokiʻoki):
I kēia manawa, i ke koho ʻana a i ʻole ke koho ʻana i nā mea slicer (hiki iā ʻoe ke hoʻohana i nā kī Ctrl и Shift, a me ka swiping me ka pihi ʻiole hema e koho i ka nui) e hōʻike ka papa pivot i nā ʻikepili kānana no nā mea i koho ʻia. ʻO kahi nuance maikaʻi ʻē aʻe, ʻo ka ʻāpana i nā kala like ʻole e hōʻike ʻia ʻaʻole i koho wale ʻia, akā i nā mea ʻole hoʻi i loaʻa ʻole kahi waiwai i ka papa kumu:
Inā hoʻohana ʻoe i nā slicers he nui, e ʻae kēia iā ʻoe e hōʻike koke i nā pilina ma waena o nā mea ʻikepili:
Hiki ke hoʻopili maʻalahi ka mea slicer i nā Pivot Tables a me PivotCharts me ka hoʻohana ʻana i ka kiko'î (Nā koho) pihi Nā Hoʻohui Pivot Table (Pivot table connections)e wehe ana i ka pahu kamaʻilio e pili ana:
A laila e pili ana ke koho ʻana i nā mea ma ka ʻāpana hoʻokahi i nā papa a me nā kiʻi i ka manawa hoʻokahi, a ma nā ʻāpana like ʻole paha.
ʻAʻole i poina ʻia ka ʻāpana hoʻolālā. No ka hoʻopololei ʻana i nā mea ʻoki ma kahi pā Kukahula (Hoʻolālā) Nui nā ʻano inline:
… a me ka hiki ke hana i kāu mau koho hoʻolālā ponoʻī:
A i ka hui "pivot table - pivot chart - slice", he nani loa kēia mau mea a pau:
- He aha nā papa pivot a pehea e kūkulu ai iā lākou
- Ka hui pū ʻana i nā helu a me nā lā me ka pae i makemake ʻia i nā papa pivot
- Ke kūkulu ʻana i kahi hōʻike Pivottable ma nā pae he nui o ka ʻikepili kumu
- Hoʻonohonoho i nā helu ʻana ma Pivot Tables