{"id":4565,"date":"2025-10-17T13:12:54","date_gmt":"2025-10-17T06:12:54","guid":{"rendered":"https:\/\/hrspring.vn\/consult\/?p=4565"},"modified":"2025-10-19T09:31:20","modified_gmt":"2025-10-19T02:31:20","slug":"cach-dung-ham-groupby-de-hieu-nhat","status":"publish","type":"post","link":"https:\/\/hrspring.vn\/consult\/cach-dung-ham-groupby-de-hieu-nhat\/","title":{"rendered":"C\u00e1ch d\u00f9ng h\u00e0m GROUPBY d\u1ec5 hi\u1ec3u nh\u1ea5t"},"content":{"rendered":"
\n
\n
\n
\n
\n
\n
\n
\n
\n

C\u00e1ch d\u00f9ng h\u00e0m GROUPBY trong Excel 365 \u2013 Nh\u00f3m d\u1eef li\u1ec7u t\u1ef1 \u0111\u1ed9ng, d\u1ec5 hi\u1ec3u nh\u1ea5t<\/h1>\n

Trong Excel 365<\/strong>, vi\u1ec7c nh\u00f3m d\u1eef li\u1ec7u t\u1ef1 \u0111\u1ed9ng v\u00e0 linh ho\u1ea1t<\/strong> \u0111\u00e3 tr\u1edf n\u00ean d\u1ec5 d\u00e0ng h\u01a1n bao gi\u1edd h\u1ebft nh\u1edd s\u1ef1 ra \u0111\u1eddi c\u1ee7a h\u00e0m GROUPBY<\/strong>. \u0110\u00e2y l\u00e0 m\u1ed9t trong nh\u1eefng h\u00e0m m\u1edbi m\u1ea1nh m\u1ebd c\u1ee7a Excel<\/strong>, cho ph\u00e9p b\u1ea1n nh\u00f3m d\u1eef li\u1ec7u theo m\u1ed9t ho\u1eb7c nhi\u1ec1u ti\u00eau ch\u00ed<\/strong>, \u0111\u1ed3ng th\u1eddi t\u00ednh to\u00e1n t\u1ed5ng h\u1ee3p<\/strong> nh\u01b0 \u0111\u1ebfm, c\u1ed9ng, trung b\u00ecnh<\/em>\u2026 m\u00e0 tr\u01b0\u1edbc \u0111\u00e2y ch\u1ec9 c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n b\u1eb1ng Pivot Table<\/strong>, Power Query<\/strong> ho\u1eb7c c\u00e1c c\u00f4ng th\u1ee9c ph\u1ee9c t\u1ea1p<\/strong>.<\/p>\n

B\u00e0i vi\u1ebft n\u00e0y s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m GROUPBY trong Excel 365<\/strong> m\u1ed9t c\u00e1ch to\u00e0n di\u1ec7n v\u00e0 d\u1ec5 hi\u1ec3u nh\u1ea5t<\/strong> \u2013 t\u1eeb kh\u00e1i ni\u1ec7m, c\u00fa ph\u00e1p, v\u00ed d\u1ee5 th\u1ef1c t\u1ebf<\/strong>, \u0111\u1ebfn c\u00e1c m\u1eb9o k\u1ebft h\u1ee3p GROUPBY v\u1edbi nh\u1eefng h\u00e0m kh\u00e1c<\/strong> nh\u01b0 LAMBDA, BYROW, LET<\/em> v\u00e0 \u1ee9ng d\u1ee5ng n\u00e2ng cao trong ph\u00e2n t\u00edch d\u1eef li\u1ec7u<\/strong>.<\/p>\n

D\u00f9 b\u1ea1n l\u00e0 ng\u01b0\u1eddi m\u1edbi h\u1ecdc Excel<\/strong> hay chuy\u00ean vi\u00ean ph\u00e2n t\u00edch d\u1eef li\u1ec7u<\/strong>, vi\u1ec7c l\u00e0m ch\u1ee7 h\u00e0m GROUPBY<\/strong> s\u1ebd gi\u00fap b\u1ea1n t\u1ef1 \u0111\u1ed9ng h\u00f3a quy tr\u00ecnh x\u1eed l\u00fd d\u1eef li\u1ec7u<\/strong>, ti\u1ebft ki\u1ec7m th\u1eddi gian<\/strong> v\u00e0 n\u00e2ng cao t\u00ednh chuy\u00ean nghi\u1ec7p<\/strong> trong c\u00f4ng vi\u1ec7c h\u00e0ng ng\u00e0y.<\/p>\n<\/div>\n<\/div>\n

\n

1. C\u00fa ph\u00e1p h\u00e0m GROUPBY<\/strong><\/h2>\n<\/div>\n
\n
\n

=GROUPBY(row_fields, values, function, [field_headers], [total_depth], [sort_order], [filter_array], [field_relationship])<\/strong><\/p>\n<\/div>\n<\/div>\n

\n
\n

\u00dd ngh\u0129a c\u00e1c tham s\u1ed1 c\u1ee7a h\u00e0m GROUPBY:<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n

\n
\n
\n
\n

B\u1ea3ng tham s\u1ed1 h\u00e0m GROUPBY<\/h2>\n
\n\n\n\n\n\n\n\n\n\n\n\n\n
Tham s\u1ed1<\/th>\nB\u1eaft bu\u1ed9c\/ T\u00f9y ch\u1ecdn<\/th>\nGi\u1ea3i th\u00edch chi ti\u1ebft<\/th>\n<\/tr>\n<\/thead>\n
row_fields<\/strong><\/td>\nB\u1eaft bu\u1ed9c<\/td>\nM\u1ea3ng (array) ch\u1ee9a c\u00e1c tr\u01b0\u1eddng (fields) d\u00f9ng \u0111\u1ec3 nh\u00f3m d\u00f2ng (gi\u1ed1ng nh\u01b0 “Group by” theo c\u1ed9t n\u00e0o).<\/td>\n<\/tr>\n
values<\/strong><\/td>\nB\u1eaft bu\u1ed9c<\/td>\nM\u1ea3ng gi\u00e1 tr\u1ecb m\u00e0 b\u1ea1n mu\u1ed1n th\u1ef1c hi\u1ec7n ph\u00e9p t\u00ednh (nh\u01b0 c\u1ed9ng t\u1ed5ng, \u0111\u1ebfm, trung b\u00ecnh…).<\/td>\n<\/tr>\n
function<\/strong><\/td>\nB\u1eaft bu\u1ed9c<\/td>\nH\u00e0m \u00e1p d\u1ee5ng: “SUM”, “COUNT”, “AVERAGE”, “MAX”, “MIN”, ho\u1eb7c LAMBDA.<\/td>\n<\/tr>\n
field_headers<\/strong><\/td>\nT\u00f9y ch\u1ecdn<\/td>\nTi\u00eau \u0111\u1ec1 cho c\u00e1c c\u1ed9t k\u1ebft qu\u1ea3.<\/td>\n<\/tr>\n
total_depth<\/strong><\/td>\nT\u00f9y ch\u1ecdn<\/td>\nM\u1ee9c \u0111\u1ed9 nh\u00f3m nhi\u1ec1u c\u1ea5p (v\u00ed d\u1ee5 theo “V\u00f9ng” r\u1ed3i “Qu\u1ed1c gia”).<\/td>\n<\/tr>\n
sort_order<\/strong><\/td>\nT\u00f9y ch\u1ecdn<\/td>\nS\u1eafp x\u1ebfp t\u0103ng (1) ho\u1eb7c gi\u1ea3m (-1). M\u1eb7c \u0111\u1ecbnh l\u00e0 1.<\/td>\n<\/tr>\n
filter_array<\/strong><\/td>\nT\u00f9y ch\u1ecdn<\/td>\n\u0110i\u1ec1u ki\u1ec7n l\u1ecdc d\u1eef li\u1ec7u tr\u01b0\u1edbc khi nh\u00f3m.<\/td>\n<\/tr>\n
field_relationship<\/strong><\/td>\nT\u00f9y ch\u1ecdn<\/td>\nM\u00f4 t\u1ea3 quan h\u1ec7 gi\u1eefa c\u00e1c field khi nh\u00f3m ph\u1ee9c t\u1ea1p.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n
\n
\n
\n
\n
\n
\n
\n

Ta c\u00f3 th\u1ec3 di\u1ec5n gi\u1ea3i c\u00e1c tham s\u1ed1 n\u00e0y d\u1ec5 hi\u1ec3u h\u01a1n nh\u01b0 sau.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n

\n
\n
\n
\n
\n
\n
\n
\n
\"\"<\/p>\n
<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n
\n
\n
\n
\n
\n
\n

2. C\u00e1c v\u00ed d\u1ee5 th\u1ef1c chi\u1ebfn s\u1eed d\u1ee5ng h\u00e0m GROUPBY trong th\u1ef1c t\u1ebf<\/strong><\/h2>\n<\/div>\n
\n

2.1. GROUPBY \u0111\u01a1n gi\u1ea3n theo 1 c\u1ed9t d\u1eef li\u1ec7u trong Excel<\/strong><\/p>\n<\/div>\n

\n
\n

\u0110\u1ec3 demo ph\u1ea7n n\u00e0y m\u00ecnh \u0111ang s\u1eed d\u1ee5ng kh\u1ed1i d\u1eef li\u1ec7u nh\u01b0 h\u00ecnh d\u01b0\u1edbi.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n

\n
\n
\n
\n
<\/a><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n
\n
\n
\n
\n
\n
\n
\n

D\u1eef li\u1ec7u \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng trong b\u00e0i n\u00e0y l\u00e0 ki\u1ec3u d\u1eef li\u1ec7u d\u1ea1ng Table c\u00f3 t\u00ean l\u00e0\u00a0DATA_GROUPBY<\/strong>.<\/p>\n

Trong v\u00ed d\u1ee5 \u0111\u1ea7u ti\u00ean n\u00e0y m\u00ecnh s\u1ebd ch\u1ecdn c\u1ed9t ProductName v\u00e0 Amount \u0111\u1ec3 \u0111\u01b0a v\u00e0o h\u00e0m\u00a0GROUPBY<\/strong>. L\u01b0u \u00fd l\u00e0 m\u00ecnh ch\u1ecdn d\u1eef li\u1ec7u n\u00e0y s\u1ebd bao g\u1ed3m c\u1ea3 ti\u00eau \u0111\u1ec1.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n

\n
\n
\n
\n
<\/a><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n
\n
\n
\n
\n
\n
\n
\n

\u0110\u00e2y l\u00e0 h\u00e0m m\u00ecnh \u0111\u00e3 vi\u1ebft.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n

\n
\n
\n
\n
\n
\n
=GROUPBY(DATA_GROUPBY[[#All],[ProductName]], DATA_GROUPBY[[#All],[Amount]], SUM, 3)<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n
\n
\n
\n
\n
\n
\n
\n

V\u00e0 \u0111\u00e2y l\u00e0 k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n

\n
\n
\n
\n
<\/a><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n
\n
\n
\n
\n
\n
\n
\n

Gi\u1ea3i th\u00edch 1 ch\u00fat th\u00ec \u1edf \u0111\u00e2y ch\u00fang ta ch\u1ecdn\u00a0row_fields\u00a0<\/strong>l\u00e0 c\u1ed9t\u00a0ProductName<\/strong>.<\/p>\n

Values\u00a0<\/strong>m\u00ecnh l\u1ef1a ch\u1ecdn l\u00e0 c\u1ed9t\u00a0Amount<\/strong>.<\/p>\n

Function<\/strong>\u00a0\u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u1edf \u0111\u00e2y l\u00e0\u00a0SUM<\/strong>.<\/p>\n

V\u1edbi ph\u1ea7n\u00a0field_headers\u00a0<\/strong>th\u00ec m\u00ecnh l\u1ef1a ch\u1ecdn s\u1ed1 3 ngh\u0129a l\u00e0\u00a0yes and show<\/strong>.<\/p>\n

M\u1eb7c \u0111\u1ecbnh v\u1edbi ph\u1ea7n field_headers ta c\u00f3 3 l\u1ef1a ch\u1ecdn l\u1ea7n l\u01b0\u1ee3t l\u00e0:\u00a00 \u2013 N<\/span>o, 1 \u2013 Yes but don\u2019t show, 2 \u2013 No but generate, 3 \u2013 Yes and show.<\/strong><\/p>\n

\u0110a ph\u1ea7n khi vi\u1ebft c\u00f4ng th\u1ee9c\u00a0GROUPBY\u00a0<\/strong>ch\u00fang ta s\u1ebd l\u1ef1a ch\u1ecdn tu\u1ef3 theo c\u00f4ng th\u1ee9c m\u00e0 ch\u00fang ta vi\u1ebft.<\/p>\n

– N\u1ebfu b\u1ea1n ch\u1ecdn\u00a0field_headers = 0<\/strong>\u00a0\u2013 No<\/strong>\u00a0th\u00ec b\u1ea1n \u0111ang th\u00f4ng b\u00e1o cho Excel bi\u1ebft l\u00e0 d\u1eef li\u1ec7u c\u1ee7a ch\u00fang ta kh\u00f4ng c\u00f3 ti\u00eau \u0111\u1ec1.<\/p>\n

– N\u1ebfu b\u1ea1n ch\u1ecdn\u00a0field_headers = 1<\/strong>\u00a0\u2013 Yes but don\u2019t show<\/strong>\u00a0th\u00ec b\u1ea1n \u0111ang th\u00f4ng b\u00e1o cho Excel bi\u1ebft l\u00e0 d\u1eef li\u1ec7u c\u1ee7a ch\u00fang ta c\u00f3 ti\u00eau \u0111\u1ec1. T\u1ee9c l\u00e0 ch\u00fang ta s\u1ebd l\u1ea5y d\u00f2ng \u0111\u1ea7u ti\u00ean trong v\u00f9ng d\u1eef li\u1ec7u b\u1ea1n ch\u1ecdn \u0111\u1ec3 l\u00e0m ti\u00eau \u0111\u1ec1. V\u00ed d\u1ee5 nh\u01b0 tr\u00ean th\u00ec ti\u00eau \u0111\u1ec1 l\u1ea7n l\u01b0\u1ee3t s\u1ebd l\u00e0 ProductName v\u00e0 Amount.<\/p>\n

– N\u1ebfu b\u1ea1n ch\u1ecdn\u00a0field_headers = 2 \u2013 No but generate<\/strong>\u00a0th\u00ec c\u00f3 ngh\u0129a l\u00e0 d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n kh\u00f4ng c\u00f3 ti\u00eau \u0111\u1ec1, l\u00fac n\u00e0y Excel s\u1ebd t\u1ef1 t\u1ea1o ra (generate) ra 1 ti\u00eau \u0111\u1ec1 theo \u00fd n\u00f3 cho b\u1ea1n. M\u00ecnh khuy\u1ebfn kh\u00edch b\u1ea1n kh\u00f4ng n\u00ean s\u1eed d\u1ee5ng t\u00ednh n\u0103ng n\u00e0y.<\/p>\n

– N\u1ebfu b\u1ea1n ch\u1ecdn\u00a0field_headers = 3 \u2013 Yes and show<\/strong>. L\u00fac n\u00e0y th\u00ec b\u1ea1n \u0111\u00e3 th\u00f4ng b\u00e1o cho Excel bi\u1ebft b\u1ea1n c\u00f3 ti\u00eau \u0111\u1ec1 (d\u00f2ng \u0111\u1ea7u ti\u00ean m\u1eb7c \u0111\u1ecbnh \u0111\u01b0\u1ee3c hi\u1ec3u l\u00e0 d\u00f2ng l\u1ea5y l\u00e0m ti\u00eau \u0111\u1ec1) v\u00e0 b\u1ea1n mu\u1ed1n hi\u1ec3n th\u1ecb ra n\u00f3. \u0110\u00e2y l\u00e0 1 trong c\u00e1c l\u1ef1a ch\u1ecdn m\u00ecnh r\u1ea5t hay s\u1eed d\u1ee5ng.<\/p>\n

B\u1ea1n c\u00f3 th\u1ec3 th\u1ea5y trong c\u00f4ng th\u1ee9c m\u00ecnh \u0111\u00e3 \u0111\u01b0a l\u00ean tr\u00ean c\u00f3 \u0111o\u1ea1n \u201cDATA_GROUPBY[[#All],[ProductName]]<\/strong>\u201d. \u0110o\u1ea1n n\u00e0y c\u00f3 \u00fd ngh\u0129a l\u00e0 b\u1ea1n l\u1ea5y ra to\u00e0n b\u1ed9 c\u1ed9t ProductName bao g\u1ed3m c\u1ea3 ti\u00eau \u0111\u1ec1.<\/p>\n

Th\u01b0\u1eddng khi vi\u1ebft c\u00f4ng th\u1ee9c trong Excel th\u00ec c\u00e1c b\u1ea1n khi mu\u1ed1n tham chi\u1ebfu \u0111\u1ebfn c\u1ed9t ProductName th\u00ec c\u00e1c b\u1ea1n s\u1ebd vi\u1ebft l\u00e0\u00a0DATA_GROUPBY[ProductName]<\/strong>. V\u1eady 2 ph\u1ea7n tham chi\u1ebfu tr\u00ean kh\u00e1c nhau nh\u01b0 th\u1ebf n\u00e0o?<\/p>\n

D\u01b0\u1edbi \u0111\u00e2y l\u00e0 tham chi\u1ebfu khi b\u1ea1n ch\u1ecdn\u00a0DATA_GROUPBY\u00a0<\/strong>c\u00f3 [#All] v\u00e0 kh\u00f4ng c\u00f3 [#All]\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n

\n
\n
\n
\n
\n
\n
\n

D\u01b0\u1edbi \u0111\u00e2y l\u00e0 tham chi\u1ebfu khi b\u1ea1n ch\u1ecdn
\nDATA_GROUPBY[[#All],[ProductName]]<\/strong><\/h3>\n

\"Reference<\/div>\n

\n

C\u00f2n \u0111\u00e2y l\u00e0 tham chi\u1ebfu khi b\u1ea1n ch\u1ecdn
\nDATA_GROUPBY[ProductName]<\/strong><\/h3>\n

\"Reference<\/div>\n<\/div>\n<\/section>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n

\n
\n
\n
\n
\n
\n
\n
\n
\n

\u0110i\u1ec3m kh\u00e1c bi\u1ec7t gi\u1eefa 2 tham chi\u1ebfu n\u00e0y \u0111\u00f3 l\u00e0 tham chi\u1ebfu b\u00ean tr\u00ean s\u1ebd bao g\u1ed3m c\u1ea3 Header c\u00f2n tham chi\u1ebfu b\u00ean d\u01b0\u1edbi th\u00ec kh\u00f4ng?<\/p>\n

V\u00ec v\u1eady n\u1ebfu ta s\u1eed d\u1ee5ng tham chi\u1ebfu nh\u01b0 b\u00ean d\u01b0\u1edbi m\u00e0 vi\u1ebft c\u00f4ng th\u1ee9c GROUPBY th\u00ec k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 s\u1ebd l\u00e0 g\u00ec?<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n

\n
\n
\n
\n
\n
\n
=GROUPBY(DATA_GROUPBY[ProductName],DATA_GROUPBY[Amount],SUM,3)<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n
\n
\n
\n
\n
\n
\n
\n

\u0110\u00e2y l\u00e0 k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 c\u1ee7a c\u00f4ng th\u1ee9c tr\u00ean<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n

\n
\n
\n
\n
<\/a><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n
\n
\n
\n
\n
\n
\n
\n

B\u1ea1n s\u1ebd th\u1ea5y h\u01a1i sai sai \u0111\u00fang kh\u00f4ng? T\u1ea1i sao l\u1ea1i xu\u1ea5t hi\u1ec7n Cap Sleeve l\u00e0 Header?<\/p>\n

V\u00ec d\u00f2ng Cap Sleeve c\u00f3 gi\u00e1 tr\u1ecb Amount = 164.7 l\u00e0 gi\u00e1 tr\u1ecb d\u00f2ng \u0111\u1ea7u ti\u00ean xu\u1ea5t hi\u1ec7n trong b\u1ea3ng d\u1eef li\u1ec7u c\u1ee7a ch\u00fang ta.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n

\n
\n
\n
\n
<\/a><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n
\n
\n
\n
\n
\n
\n
\n

V\u1eady trong tr\u01b0\u1eddng h\u1ee3p m\u00ecnh v\u1eabn mu\u1ed1n s\u1eed d\u1ee5ng c\u00fa ph\u00e1p tham chi\u1ebfu ri\u00eang ph\u1ea7n Data kh\u00f4ng bao g\u1ed3m Header cho \u0111\u01a1n gi\u1ea3n v\u00e0 v\u1eabn mu\u1ed1n c\u00f3 ti\u00eau \u0111\u1ec1 th\u00ec l\u00e0m sao?<\/p>\n

C\u00e1ch \u0111\u01a1n gi\u1ea3n l\u00e0 ch\u00fang ta s\u1ebd d\u00f9ng h\u00e0m VSTACK gh\u00e9p ph\u1ea7n ti\u00eau \u0111\u1ec1 v\u00e0o k\u1ebft qu\u1ea3 c\u1ee7a h\u00e0m GROUPBY l\u00e0 \u0111\u01b0\u1ee3c.<\/p>\n

Ngo\u00e0i ra v\u1edbi h\u00e0m GROUPBY th\u00ec m\u00ecnh s\u1ebd s\u1eed d\u1ee5ng tham s\u1ed1 field_headers b\u1eb1ng 0 ho\u1eb7c m\u1eb7c \u0111\u1ecbnh l\u00e0 No.<\/p>\n

B\u1ea1n s\u1ebd vi\u1ebft nh\u01b0 d\u01b0\u1edbi \u0111\u00e2y.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n

\n
\n
\n
\n
\n
\n
=VSTACK({“Product Name”,”Amount”},GROUPBY(DATA_GROUPBY[ProductName],DATA_GROUPBY[Amount],SUM,0))<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n
\n
\n
\n
\n
\n
\n
\n

D\u01b0\u1edbi \u0111\u00e2y l\u00e0 k\u1ebft qu\u1ea3 c\u1ee7a c\u00f4ng th\u1ee9c tr\u00ean<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n

\n
\n
\n
\n
<\/a><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n
\n
\n
\n
\n
\n
\n
\n

Th\u1ef1c ra trong th\u1ef1c t\u1ebf, khi b\u1ea1n mu\u1ed1n t\u1ea1o ra Header theo \u00fd m\u00ecnh thay v\u00ec Header m\u1eb7c \u0111\u1ecbnh \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng t\u1eeb Header c\u1ee7a Table d\u1eef li\u1ec7u g\u1ed1c th\u00ec \u0111\u00e2y l\u00e0 c\u00e1ch b\u1ea1n n\u00ean s\u1eed d\u1ee5ng.<\/p>\n

C\u00e1c b\u1ea1n c\u00f3 th\u1ec3 th\u1ef1c h\u00e0nh c\u00e1c ki\u1ebfn th\u1ee9c v\u1eeba r\u1ed3i v\u1edbi d\u1eef li\u1ec7u \u1edf Sheet\u00a0GROUPBY_01<\/strong>\u00a0d\u01b0\u1edbi \u0111\u00e2y.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n

\n
\n
\n
\n