Papa Pivot Excel: hoʻoikaika kino

No ka hoʻomaopopo maikaʻi ʻana i nā pahuhopu a me nā hopena o ka hoʻohana ʻana i PivotTable ma Excel, e ʻike i kahi alakaʻi i kēlā me kēia ʻanuʻu i ka hana ʻana i PivotTable ma Excel.

No kēia hiʻohiʻona maʻalahi mākou e hoʻohana i kahi pālahalaha, kahi e papa inoa ai i ka ʻikepili kūʻai o kahi hui.

Hōʻike ka pāpalapala i ka lā kūʻai, ka inoa o ka mea kūʻai aku, ka ʻāina, ka ʻāpana a me ka huli ʻana.

Hoʻokumu kēia laʻana i kahi papa pivot e hōʻike ana i ka nui o nā kūʻai aku no kēlā me kēia mahina o ka makahiki, i wāwahi ʻia e ka moku kūʻai aku a me ka luna kūʻai. ʻO ke kaʻina hana e hana i kēia papa pivot penei:

1. E koho i kekahi kelepona i loko o ka laulā ʻikepili o koho i ka laulā ikepili holoʻokoʻa e hoʻohana ai ma ka Pivot Table.
2. Kaomi i ka pihi PivotTable, aia i loko o ka hui "Table", ma ka ʻaoʻao "Insert" o ka lipine Excel.

3. E hōʻike ʻia ʻoe me ka pahu kamaʻilio "Create PivotTable".

E hōʻoia e pili ana ka laulā i koho ʻia i ka laulā o nā cell āu e makemake ai e hoʻohana no ka papa pivot (inā ʻoe e hana i kahi papaʻaina, e like me ka laʻana, ʻoi aku ka maʻalahi o nā mea āpau no ka mea e pili ana ʻoe i ka papaʻaina a ʻaʻole i nā hoʻonohonoho).

Aia kekahi koho e nīnau iā ʻoe i kahi āu e makemake ai e kau i ka papa pivot. ʻAe kēia iā ʻoe e kau i ka papa pivot i loko o kahi pepa hana i kuhikuhi ʻia. A i ʻole, koho i ke koho muadefinita hou pepa hana .

Kaomi OK .

4. E hōʻike ʻia iā ʻoe i kēia manawa me hoʻokahi pākaukau pivot blank a me ka papa hana papa inoa PivotTable, aia kekahi mau kahua ʻikepili. E ʻoluʻolu e hoʻomaopopo ʻo ia nā poʻomanaʻo o ka palahalaha ʻikepili mua.

Makemake mākou i ka pākaukau pivot hōʻike i nā huina o nā ʻikepili kūʻai aku no kēlā me kēia mahina, i wāwahi ʻia e ka ʻāina a me ka luna kūʻai.

No laila, mai ka "PivotTable Field List" pane hana:

• Kauo i ke kahua "Date” ma kahi i kaha ʻia “Rows";
• Kauo i ke kahua "Sales” ma kahi i kaha ʻia “Values Σ";
• Kauo i ke kahua "Province” ma kahi i kaha ʻia “Columns";
• Kauo i ka "Seller“. ma kahi i kapa ʻia ʻo "Columns".

5. E hoʻopiha ʻia ka papa kuhikuhi pivot me nā huina kūʻai i kēlā me kēia lā no kēlā me kēia wahi kūʻai aku a me kēlā me kēia luna kūʻai, e like me ka hōʻike ʻana ma lalo nei.

E like me kāu e ʻike ai, ua hui pū ʻia nā lā e ka mahina, me ka huina ʻāpana pili o ka nui (e pili ana kēia hui ʻokoʻa i ka mana o Excel, me nā mana o mua he pono e hui ʻia ma ka mahina, me ka lima).

Hiki iā ʻoe ke hoʻonohonoho i nā ʻano i nā cell, e like me ke kālā no nā helu no ka mea he mau kālā kālā.

Nā kānana hōʻike PivotTable

Hāʻawi ka kānana hōʻike PivotTable iā ʻoe e nānā i ka ʻikepili no kahi waiwai hoʻokahi a i ʻole kahi koho o nā waiwai i hōʻike ʻia ma nā kahua ʻikepili.

No ka laʻana, ma ka Pivot Table ma mua, ʻike paha ʻoe i ka ʻikepili ma nā wahi kūʻai aku, e like me kahi panalāʻau.

No ka ʻike wale ʻana i ka ʻikepili no ka ʻāina ʻo Turin (TO), e hoʻi i ka pane hana "PivotTable Field List" a kauo i ke poʻomanaʻo kahua "Province" i loko o ka ʻāpana "Report Filter" (a i ʻole "Filters").

E ʻike ʻoe aia kahi kahua "Kalana" ma ka piko o ka papa kuhikuhi. E hoʻohana i ka papa inoa hāʻule i lalo i kēia kahua e koho i ka mokuʻo Turin. Hōʻike ka papa pivot i nā kūʻai wale no ka ʻāina ʻo Turin.

Hiki iā ʻoe ke ʻike koke i nā kūʻai aku no ka ʻāina ʻo Piedmont ma ke koho ʻana i nā Panalāʻau āpau i ʻāpana o ka ʻāina Piedmont mai ka papa kuhikuhi iho.

Ercole Palmeri