Excel Tips: 兩個在Pivot Table 必學 Grouping 方法. 增強分析能力👍

下載示範文檔
1drv.ms/x/s!Am...
#Grouping in Pivot Table

[@emmywong8093]

Thank you !

[@KKLeung]

You're welcome!

[@cynnhey]

好好用的PIVOT TABLE, THANKS !

[@KKLeung]

Hi Cynthia
多謝收看

[@quietlea4997]

呢個勁實用 謝謝 你講解清晰又易明

[@KKLeung]

多謝收看

[@kelvinwu8117]

非常實用👍 請問如果在Grouping 食物時，不小心把蘋果group 落去vegetable，請問如何可以更改錯誤，把蘋果group落去 fruit? 是不是要重新再做過﹖

[@KKLeung]

Hi Kevin,
多謝收看。我也試過，但找不到修改方法，要ungroup 再做。

[@kelvinwu8117]

@@KKLeung Ok, thanks

[@martylai1198]

我有6年data，有冇辦法group by financial year， 即係每年4月1日至下年3月31日。我試過可以group成quarter再group成 year. 麻煩你指教一下。

[@patrick_2024]

Hi KK Sir, 請問呢個grouping可否用在計算Depreciation? 如果可以的話，如何setup一個template? 中秋節快樂🎉

[@KKLeung]

多謝收看
要計算depreciation, 可能要用到 Calculated field 或者 calculated item, 請參考下列兩個影片
th-cam.com/video/7pxT2QIks3g/w-d-xo.htmlsi=BOE6CZV4duXkHTh2
th-cam.com/video/B0QJ9VIdvDA/w-d-xo.htmlsi=SIvKmlrYuiRoJrNb

[@patrick_2024]

Thanks KK Sir

[@ultimatedancing1014]

Very useful
Thanks

[@KKLeung]

多謝你嘅好評，協助轉介給有需要嘅朋友，就是對本平台嘅義工們最大支持。👍

[@lben1705]

Thank you teacher

[@KKLeung]

@@lben1705 thanks for watching

[@stevenlylaw7667]

Excellent

[@KKLeung]

Hi Steven
多謝你嘅好評，協助轉介給有需要嘅朋友，就是對本平台嘅義工們最大支持。👍

[@musicismusic756]

好實用，好清晰，謝謝老師

[@KKLeung]

多謝收看

[@paulyeung5628]

謝謝老師👍👍👍🙏

[@KKLeung]

Hi Paul, 多謝收看

[@abc68chow37]

👍👏😊

[@KKLeung]

多謝收看😀