{"id":2224,"date":"2024-12-02T07:17:09","date_gmt":"2024-12-02T07:17:09","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/cach-nhom-du-lieu-trong-excel-pivot-table\/"},"modified":"2024-12-02T07:17:09","modified_gmt":"2024-12-02T07:17:09","slug":"cach-nhom-du-lieu-trong-excel-pivot-table","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/cach-nhom-du-lieu-trong-excel-pivot-table\/","title":{"rendered":"C\u00c1CH NH\u00d3M D\u1eee LI\u1ec6U TRONG EXCEL PIVOT TABLE"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p><em><span style=\"font-weight: 400\">Nh\u00f3m d\u1eef li\u1ec7u trong Excel PivotTable \u0111\u1ec3 gi\u00fap t\u00f3m t\u1eaft v\u00e0 ph\u00e2n t\u00edch th\u00eam d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n. <\/span><span style=\"font-weight: 400\">Khi l\u00e0m vi\u1ec7c vi\u1ec7c v\u1edbi PivotTable trong Excel, b\u1ea1n c\u00f3 th\u1ec3 th\u1ea5y r\u1eb1ng m\u00ecnh c\u00f3 nhi\u1ec1u d\u1eef li\u1ec7u trong b\u1ea3ng c\u1ea7n \u0111\u01b0\u1ee3c t\u00f3m t\u1eaft th\u00eam. \u0110i\u1ec1u n\u00e0y c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n b\u1eb1ng <strong>c\u00e1ch nh\u00f3m d\u1eef li\u1ec7u<\/strong> v\u00e0 trong b\u00e0i \u0111\u0103ng n\u00e0y,\u00a0 <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc Excel Online<\/strong><\/a> s\u1ebd gi\u1ea3i th\u00edch c\u00e1ch th\u1ef1c hi\u1ec7n \u0111i\u1ec1u n\u00e0y.<\/span><\/em><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_61 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\">Xem nhanh<\/p>\n<p><label for=\"ez-toc-cssicon-toggle-item-674d5ef3d4260\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><\/span><\/span><\/label><\/p>\n<nav>\n<ul class=\"ez-toc-list ez-toc-list-level-1 \">\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/cach-nhom-du-lieu-trong-excel-pivot-table.html#Nhom_theo_gia_tri\" title=\"Nh\u00f3m theo gi\u00e1 tr\u1ecb\">Nh\u00f3m theo gi\u00e1 tr\u1ecb<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/cach-nhom-du-lieu-trong-excel-pivot-table.html#Nhom_theo_ngay\" title=\"Nh\u00f3m theo ng\u00e0y\">Nh\u00f3m theo ng\u00e0y<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/cach-nhom-du-lieu-trong-excel-pivot-table.html#Nhom_du_lieu_theo_cach_thu_cong\" title=\"Nh\u00f3m d\u1eef li\u1ec7u theo c\u00e1ch th\u1ee7 c\u00f4ng\">Nh\u00f3m d\u1eef li\u1ec7u theo c\u00e1ch th\u1ee7 c\u00f4ng<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/cach-nhom-du-lieu-trong-excel-pivot-table.html#Khac_phuc_su_co_loi\" title=\"Kh\u1eafc ph\u1ee5c s\u1ef1 c\u1ed1 l\u1ed7i\">Kh\u1eafc ph\u1ee5c s\u1ef1 c\u1ed1 l\u1ed7i<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/cach-nhom-du-lieu-trong-excel-pivot-table.html#Mo_rong_cac_nhom\" title=\"M\u1edf r\u1ed9ng c\u00e1c nh\u00f3m\">M\u1edf r\u1ed9ng c\u00e1c nh\u00f3m<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/cach-nhom-du-lieu-trong-excel-pivot-table.html#Nhom_va_nhieu_hop_nhat_nhieu_vung_du_lieu\" title=\"Nh\u00f3m v\u00e0 nhi\u1ec1u h\u1ee3p nh\u1ea5t nhi\u1ec1u v\u00f9ng d\u1eef li\u1ec7u\">Nh\u00f3m v\u00e0 nhi\u1ec1u h\u1ee3p nh\u1ea5t nhi\u1ec1u v\u00f9ng d\u1eef li\u1ec7u<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Nhom_theo_gia_tri\"><\/span><b>Nh\u00f3m theo gi\u00e1 tr\u1ecb<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">Xem x\u00e9t tr\u01b0\u1eddng h\u1ee3p d\u1eef li\u1ec7u <a href=\"http:\/\/blog.ezworkapp.com\/khoi-dau-voi-pivot-table-trong-excel.html\"><strong>PivotTable<\/strong><\/a> c\u1ee7a b\u1ea1n bao g\u1ed3m m\u1ed9t lo\u1ea1t h\u00f3a \u0111\u01a1n m\u00e0 b\u1ea1n \u0111ang x\u1eed l\u00fd. B\u1ea1n c\u00f3 th\u1ec3 t\u1ed1i gi\u1ea3n c\u00e1c h\u00f3a \u0111\u01a1n b\u1eb1ng nh\u00f3m c\u00e1c nh\u00f3m 5, 10 ho\u1eb7c th\u1eadm ch\u00ed 100 h\u00f3a \u0111\u01a1n. V\u00ec v\u1eady, h\u00e3y xem x\u00e9t v\u00ed d\u1ee5 n\u00e0y trong \u0111\u00f3 ID \u0111\u01a1n h\u00e0ng l\u00e0 m\u1ed9t nh\u00e3n h\u00e0ng v\u00e0 m\u1ed9t tr\u01b0\u1eddng s\u1ed1. Ngay b\u00e2y gi\u1edd c\u00f3 m\u1ed9t h\u00e0ng cho m\u1ed7i \u0111\u01a1n \u0111\u1eb7t h\u00e0ng l\u00e0 qu\u00e1 ph\u1ee9c t\u1ea1p \u2013 ch\u00fang ta c\u00f3 th\u1ec3 nh\u00f3m c\u00e1c h\u00e0ng n\u00e0y l\u1ea1i \u0111\u1ec3 \u0111\u01a1n gi\u1ea3n h\u00f3a b\u1ea3ng.<\/span><\/p>\n<figure id=\"attachment_33534\" aria-describedby=\"caption-attachment-33534\" style=\"width: 700px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-33534\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cach-nhom-du-lieu-trong-excel-pivot-table-1.jpg\" alt=\"C\u00c1CH NH\u00d3M D\u1eee LI\u1ec6U TRONG EXCEL PIVOT TABLE 1\" width=\"700\" height=\"757\" title=\"cach-nhom-du-lieu-trong-excel-pivot-table-1\"><figcaption id=\"caption-attachment-33534\" class=\"wp-caption-text\">C\u00c1CH NH\u00d3M D\u1eee LI\u1ec6U TRONG EXCEL PIVOT TABLE 1<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">Trong PivotTable n\u00e0y, c\u00f3 m\u1ed7i OrderID ri\u00eang l\u1ebb \u0111\u01b0\u1ee3c tr\u00ecnh b\u00e0y trong m\u1ed9t h\u00e0ng c\u1ee7a b\u1ea3ng.<\/span><\/p>\n<p><span style=\"font-weight: 400\">\u0110\u1ec3 th\u1ef1c hi\u1ec7n vi\u1ec7c n\u00e0y, h\u00e3y nh\u1ea5p chu\u1ed9t v\u00e0o m\u1ed9t trong c\u00e1c ID \u0111\u01a1n h\u00e0ng trong PivotTable v\u00e0 ch\u1ecdn Group. V\u00ec ID \u0111\u1ec3 \u0111\u1eb7t h\u00e0ng l\u00e0 m\u1ed9t tr\u01b0\u1eddng s\u1ed1 n\u00ean h\u1ed9p tho\u1ea1i s\u1ebd \u0111\u01b0\u1ee3c \u0111\u1ecbnh c\u1ea5u h\u00ecnh \u0111\u1ec3 nh\u00f3m s\u1ed1 v\u1edbi gi\u00e1 tr\u1ecb Starting At, Ending At v\u00e0 By value. Ngay b\u00e2y gi\u1edd, Excel \u0111\u1ec1 xu\u1ea5t b\u1ea1n nh\u00f3m c\u00e1c m\u1ee5c theo b\u1ed9i s\u1ed1 m\u01b0\u1eddi c\u1ee7a gi\u00e1 tr\u1ecb Starting.<\/span><\/p>\n<p><span style=\"font-weight: 400\">Gi\u00e1 tr\u1ecb Starting At t\u1eeb m\u1eb7c \u0111\u1ecbnh m\u00e0 Excel cung c\u1ea5p l\u00e0 OrderID \u0111\u1ea7u ti\u00ean: 10248. Tuy nhi\u00ean, b\u1ea1n c\u00f3 th\u1ec3 t\u1ea1o m\u1ed9t nh\u00f3m g\u1ecdn g\u00e0ng h\u01a1n ho\u1eb7c kh\u00e1c b\u1eb1ng c\u00e1ch \u0111\u1eb7t gi\u00e1 tr\u1ecb n\u00e0y v\u00e0o h\u1ed9p Starting At \u2013 b\u1ea1n c\u00f3 th\u1ec3 \u0111\u1eb7t \u0111i\u1ec3m b\u1eaft \u0111\u1ea7u b\u1ea5t k\u1ef3 \u0111\u00e2u b\u1ea1n mu\u1ed1n ngay c\u1ea3 khi gi\u00e1 tr\u1ecb \u0111\u00f3 kh\u00f4ng t\u1ed3n t\u1ea1i trong d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n.<\/span><\/p>\n<figure id=\"attachment_33533\" aria-describedby=\"caption-attachment-33533\" style=\"width: 700px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-33533\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cach-nhom-du-lieu-trong-excel-pivot-tabl-2.jpg\" alt=\"C\u00c1CH NH\u00d3M D\u1eee LI\u1ec6U TRONG EXCEL PIVOT TABLE 2\" width=\"700\" height=\"757\" title=\"cach-nhom-du-lieu-trong-excel-pivot-tabl-2\"><figcaption id=\"caption-attachment-33533\" class=\"wp-caption-text\">C\u00c1CH NH\u00d3M D\u1eee LI\u1ec6U TRONG EXCEL PIVOT TABLE 2<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">\u1ede \u0111\u00e2y ch\u00fang ta \u0111ang thi\u1ebft l\u1eadp c\u00e1c tham s\u1ed1 \u0111\u1ec3 nh\u00f3m d\u1eef li\u1ec7u \u2013 n\u00f3 s\u1ebd \u0111\u01b0\u1ee3c OrderID nh\u00f3m th\u00e0nh c\u00e1c nh\u00f3m g\u1ed3m m\u01b0\u1eddi \u0111\u01a1n h\u00e0ng \u0111\u01b0\u1ee3c \u0111\u00e1nh s\u1ed1 li\u00ean t\u1ee5c.<\/span><\/p>\n<p><span style=\"font-weight: 400\">\u1ede \u0111\u00e2y, ch\u00fang ta \u0111\u1eb7t gi\u00e1 tr\u1ecb Starting At, ch\u00fang ta \u0111\u00e3 \u0111\u1ec3 gi\u00e1 tr\u1ecb Ending At cho Excel qu\u1ea3n l\u00fd v\u00e0 ch\u00fang ta \u0111\u1ec3 gi\u00e1 tr\u1ecb Value by t\u1ea1i 10 v\u00ec \u0111i\u1ec1u n\u00e0y ph\u00f9 h\u1ee3p v\u1edbi d\u1eef li\u1ec7u c\u1ee7a ch\u00fang ta \u2013 b\u1ea1n c\u00f3 th\u1ec3 t\u1ea1o nh\u00f3m l\u1edbn h\u01a1n ho\u1eb7c nh\u1ecf h\u01a1n b\u1eb1ng c\u00e1ch thay \u0111\u1ed5i gi\u00e1 tr\u1ecb n\u00e0y \u2013 ch\u1ecdn 5, 20, 50 ho\u1eb7c 100 r\u1ed3i b\u1ea5m OK. D\u1eef li\u1ec7u hi\u1ec7n \u0111\u01b0\u1ee3c nh\u00f3m th\u00e0nh nhi\u1ec1u ph\u1ea7n d\u1ec5 qu\u1ea3n l\u00fd d\u1ef1a tr\u00ean OrderID.<\/span><\/p>\n<div class=\"code-block code-block-3\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<p>D\u00f9 \u0111\u00e3 c\u00f3 ph\u1ea7n m\u1ec1m, nh\u01b0ng k\u1ef9 n\u0103ng Excel v\u1eabn c\u1ef1c k\u1ef3 quan tr\u1ecdng v\u1edbi k\u1ebf to\u00e1n, b\u1ea1n \u0111\u00e3 v\u1eefng Excel ch\u01b0a? H\u00e3y \u0111\u1ec3 t\u00f4i gi\u00fap b\u1ea1n, \u0111\u0103ng k\u00fd kho\u00e1 h\u1ecdc Excel:<\/p>\n<p><a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-170.gif\" title=\"ex101_92019-nho-170\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<div class=\"code-block code-block-2\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-70.gif\" title=\"vba101_92019-nho-70\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-170.gif\" title=\"ex101_92019-nho-170\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<figure id=\"attachment_33521\" aria-describedby=\"caption-attachment-33521\" style=\"width: 638px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-33521\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cach-nhom-du-lieu-trong-excel-pivot-table-3.jpg\" alt=\"C\u00c1CH NH\u00d3M D\u1eee LI\u1ec6U TRONG EXCEL PIVOT TABLE 3\" width=\"638\" height=\"529\" title=\"cach-nhom-du-lieu-trong-excel-pivot-table-3\"><figcaption id=\"caption-attachment-33521\" class=\"wp-caption-text\">C\u00c1CH NH\u00d3M D\u1eee LI\u1ec6U TRONG EXCEL PIVOT TABLE 3<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">\u0110\u00e2y l\u00e0 d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c nh\u00f3 theo OrderID \u0111\u1ec3 n\u00f3 \u0111\u01b0\u1ee3c t\u1ed1i gi\u1ea3n h\u01a1n tr\u01b0\u1edbc.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Nhom_theo_ngay\"><\/span><b>Nh\u00f3m theo ng\u00e0y<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">N\u1ebfu d\u1eef li\u1ec7u b\u1ea1n \u0111ang xem l\u00e0 d\u1eef li\u1ec7u ng\u00e0y th\u00e1ng th\u00ec b\u1ea1n c\u00f3 th\u1ec3 l\u00e0m \u0111i\u1ec1u \u0111\u00f3 t\u01b0\u01a1ng t\u1ef1. \u0110\u1ec3 nh\u00f3m d\u1eef li\u1ec7u theo ng\u00e0y, h\u00e3y nh\u1ea5p chu\u1ed9t ph\u1ea3i v\u00e0o m\u1ed9t ng\u00e0y trong c\u1ed9t ho\u1eb7c h\u00e0ng c\u1ee7a PivotTable v\u00e0 ch\u1ecdn Minutes (ph\u00fat), Hours (gi\u1edd), Days (ng\u00e0y), Months (th\u00e1ng), Quarters (qu\u00fd) hay Years (n\u0103m) v\u00e0 \u0111\u1eb7t th\u1eddi gian b\u1eaft \u0111\u1ea7u v\u00e0 k\u1ebft th\u00fac. \u0110\u1ed1i v\u1edbi c\u00e1c nh\u00f3m nh\u01b0 Year v\u00e0 Month, kho\u1ea3ng th\u1eddi gian \u0111\u01b0\u1ee3c \u0111\u1eb7t th\u00e0nh m\u1ed9t, nh\u01b0ng \u0111\u1ed1i v\u1edbi Day, b\u1ea1n c\u00f3 th\u1ec3 \u0111\u1eb7t kho\u1ea3ng th\u1eddi gian c\u1ee7a ri\u00eang m\u00ecnh \u0111\u1ec3 b\u1ea1n c\u00f3 th\u1ec3 nh\u00f3m theo kho\u1ea3ng th\u1eddi gian 7 Days (ng\u00e0y) \u0111\u1ec3 nh\u00f3m d\u1eef li\u1ec7u th\u00e0nh c\u00e1c tu\u1ea7n. \u0110\u1ec3 th\u1ef1c hi\u1ec7n vi\u1ec7c n\u00e0y, h\u00e3y ch\u1ecdn Day l\u00e0m gi\u00e1 tr\u1ecb nh\u00f3m, \u0111\u1eb7t ng\u00e0y th\u00e0nh 7, \u0111\u1eb7t gi\u00e1 tr\u1ecb Starting At th\u00e0nh m\u1ed9t ng\u00e0y m\u00e0 b\u1ea1n vi\u1ebft l\u00e0 \u0111\u1ea7u tu\u1ea7n v\u00e0 nh\u1ea5p v\u00e0o OK. Sau \u0111\u00f3, b\u1ea1n s\u1ebd c\u00f3 d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c nh\u00f3m theo tu\u1ea7n.<\/span><\/p>\n<figure id=\"attachment_33522\" aria-describedby=\"caption-attachment-33522\" style=\"width: 700px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-33522\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cach-nhom-du-lieu-trong-excel-pivot-table-4.jpg\" alt=\"C\u00c1CH NH\u00d3M D\u1eee LI\u1ec6U TRONG EXCEL PIVOT TABLE 4\" width=\"700\" height=\"935\" title=\"cach-nhom-du-lieu-trong-excel-pivot-table-4\"><figcaption id=\"caption-attachment-33522\" class=\"wp-caption-text\">C\u00c1CH NH\u00d3M D\u1eee LI\u1ec6U TRONG EXCEL PIVOT TABLE 4<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">M\u1ed9t l\u01b0\u1ee3ng l\u1edbn d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c nh\u00f3m th\u00e0nh c\u00e1c tu\u1ea7n (7 ng\u00e0y), b\u1eaft \u0111\u1ea7u t\u1eeb ch\u1ee7 nh\u1eadt (Sunday) \u2013 ng\u00e0y c\u1ee7a Starting At.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Nhom_du_lieu_theo_cach_thu_cong\"><\/span><b>Nh\u00f3m d\u1eef li\u1ec7u theo c\u00e1ch th\u1ee7 c\u00f4ng<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">\u0110\u00f4i khi kh\u00f4ng th\u1ec3 ph\u00e2n b\u1ed5 m\u1ed9t nh\u00f3m cho m\u1ed9t lo\u1ea1t c\u00e1c b\u00e1o c\u00e1o \u0111\u01a1n gi\u1ea3n nh\u01b0 m\u00f4 t\u1ea3 m\u1ed9t chu\u1ed7i s\u1ed1 ho\u1eb7c m\u1ed9t chu\u1ed7i ng\u00e0y. Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, b\u1ea1n c\u00f3 th\u1ec3 t\u1ea1o c\u00e1c nh\u00f3m ri\u00eang cho d\u1eef li\u1ec7u c\u1ee7a m\u00ecnh. V\u1edbi PivotTable tr\u00ean m\u00e0n h\u00ecnh, h\u00e3y b\u1ea5m v\u00e0o m\u1ee5c d\u1eef li\u1ec7u \u0111\u1ea7u ti\u00ean thu\u1ed9c m\u1ed9t nh\u00f3m, sau \u0111\u00f3 nh\u1ea5n Ctrl + B\u1ea5m v\u00e0o t\u1eebng m\u1ee5c kh\u00e1c thu\u1ed9c nh\u00f3m \u0111\u00f3. T\u1eeb tab PivotTable options tr\u00ean Ribbon v\u00e0 c\u00e1c m\u1ee5c \u0111\u00f3 s\u1ebd \u0111\u01b0\u1ee3c th\u00eam v\u00e0o m\u1ed9t nh\u00f3m m\u1edbi. B\u00e2y gi\u1edd b\u1ea1n c\u00f3 th\u1ec3 ti\u1ebfp t\u1ee5c v\u00e0 ch\u1ecdn c\u00e1c m\u1ee5c nh\u1eadp h\u00e0ng kh\u00e1c thu\u1ed9c v\u1ec1 h\u00e0ng ti\u1ebfp theo, l\u00ean tr\u00ean v\u00e0 t\u1ea1o m\u1ed9t nh\u00f3m cho ch\u00fang.<\/span><\/p>\n<figure id=\"attachment_33523\" aria-describedby=\"caption-attachment-33523\" style=\"width: 561px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-33523\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cach-nhom-du-lieu-trong-excel-pivot-table-5.jpg\" alt=\"C\u00c1CH NH\u00d3M D\u1eee LI\u1ec6U TRONG EXCEL PIVOT TABLE 5\" width=\"561\" height=\"559\" title=\"cach-nhom-du-lieu-trong-excel-pivot-table-5\"><figcaption id=\"caption-attachment-33523\" class=\"wp-caption-text\">C\u00c1CH NH\u00d3M D\u1eee LI\u1ec6U TRONG EXCEL PIVOT TABLE 4<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">Khi b\u1ea1n ch\u1ecdn nhi\u1ec1u t\u00ean tr\u01b0\u1eddng, b\u1ea1n c\u00f3 th\u1ec3 nh\u00f3m ch\u00fang th\u00e0nh c\u00e1c nh\u00f3m ph\u00f9 h\u1ee3p.<\/span><\/p>\n<p><span style=\"font-weight: 400\">S\u1eed d\u1ee5ng c\u00f4ng c\u1ee5 n\u00e0y, b\u1ea1n c\u00f3 th\u1ec3 nh\u00f3m d\u1eef li\u1ec7u th\u00e0nh c\u00e1c b\u1ed9 s\u01b0u t\u1eadp nh\u1ecf h\u01a1n ph\u00f9 h\u1ee3p v\u1edbi b\u1ea1n. B\u1edfi v\u00ec theo m\u1eb7c \u0111\u1ecbnh, t\u00ean nh\u00f3m l\u00e0 Group 1 v\u00e0 Group 2, b\u1ea1n s\u1ebd c\u1ea7n ph\u1ea3i ch\u1ec9nh s\u1eeda ch\u00fang \u0111\u1ec3 \u0111\u1ed5i t\u00ean \u2013 \u0111\u1ec3 th\u1ef1c hi\u1ec7n vi\u1ec7c n\u00e0y, h\u00e3y nh\u1ea5p v\u00e0o \u00f4 c\u00f3 ch\u1ee9a t\u00ean nh\u00f3m v\u00e0 trong Formula Bar nh\u1eadp t\u00ean nh\u00f3m b\u1eb1ng t\u00ean m\u00f4 t\u1ea3 nhi\u1ec1u h\u01a1n.<\/span><\/p>\n<figure id=\"attachment_33524\" aria-describedby=\"caption-attachment-33524\" style=\"width: 558px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-33524\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cach-nhom-du-lieu-trong-excel-pivot-table-6.jpg\" alt=\"C\u00c1CH NH\u00d3M D\u1eee LI\u1ec6U TRONG EXCEL PIVOT TABLE 6\" width=\"558\" height=\"595\" title=\"cach-nhom-du-lieu-trong-excel-pivot-table-6\"><figcaption id=\"caption-attachment-33524\" class=\"wp-caption-text\">C\u00c1CH NH\u00d3M D\u1eee LI\u1ec6U TRONG EXCEL PIVOT TABLE 6<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">Khi b\u1ea1n \u0111\u00e3 t\u1ea1o c\u00e1c nh\u00f3m, b\u1ea1n c\u00f3 th\u1ec3 \u0111\u1eb7t t\u00ean cho ch\u00fang b\u1ea5t c\u1ee9 t\u00ean g\u00ec b\u1ea1n mu\u1ed1n.<\/span><\/p>\n<p><span style=\"font-weight: 400\">B\u1ea1n c\u00f3 th\u1ec3 Collapse v\u00e0 Expand nh\u00f3m b\u1eb1ng c\u00e1ch nh\u1ea5p v\u00e0o bi\u1ec3u t\u01b0\u1ee3ng d\u1ea5u c\u1ed9ng \/ tr\u1eeb (+\/-) \u1edf ngay b\u00ean tr\u00e1i c\u1ee7a t\u00ean nh\u00f3m.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Khac_phuc_su_co_loi\"><\/span><b>Kh\u1eafc ph\u1ee5c s\u1ef1 c\u1ed1 l\u1ed7i<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">\u0110\u00f4i khi, khi b\u1ea1n c\u1ed1 g\u1eafng nh\u00f3m m\u1ed9t l\u1ef1a ch\u1ecdn, b\u1ea1n s\u1ebd g\u1eb7p ph\u1ea3i th\u00f4ng b\u00e1o l\u1ed7i n\u00f3i r\u1eb1ng b\u1ea1n kh\u00f4ng th\u1ec3 nh\u00f3m. C\u00f3 m\u1ed9t s\u1ed1 l\u00fd do \u0111i\u1ec1u n\u00e0y c\u00f3 th\u1ec3 x\u1ea3y ra. M\u1ed9t l\u00e0, n\u1ebfu b\u1ea1n \u0111ang c\u1ed1 g\u1eafng nh\u00f3m d\u1eef li\u1ec7u th\u00e0nh c\u00e1c nh\u00f3m t\u00f9y ch\u1ec9nh c\u1ee7a ri\u00eang m\u00ecnh, b\u1ea1n ph\u1ea3i th\u00eam hai m\u1ee5c nh\u1eadp n\u1eefa \u0111\u1ec3 t\u1ea1o nh\u00f3m \u2013 b\u1ea1n kh\u00f4ng th\u1ec3 t\u1ea1o nh\u00f3m ch\u1ec9 t\u1eeb m\u1ed9t m\u1ee5c nh\u1eadp.<\/span><\/p>\n<p><span style=\"font-weight: 400\">N\u1ebfu c\u00f3 c\u00e1c \u1ed1 tr\u1ed1ng trong tr\u01b0\u1eddng ch\u1eb3ng h\u1ea1n nh\u01b0 tr\u01b0\u1eddng ng\u00e0y ho\u1eb7c tr\u01b0\u1eddng s\u1ed1, th\u00ec b\u1ea1n s\u1ebd nh\u1eadn \u0111\u01b0\u1ee3c th\u00f4ng b\u00e1o l\u1ed7i v\u00ec \u0111i\u1ec1u n\u00e0y. B\u1ea1n c\u0169ng s\u1ebd gajep l\u1ed7i n\u1ebfu b\u1ea1n c\u00f3 m\u1ee5c nh\u1eadp v\u0103n b\u1ea3n trong tr\u01b0\u1eddng ng\u00e0y th\u00e1ng ho\u1eb7c s\u1ed1. Trong m\u1ed7i tr\u01b0\u1eddng h\u1ee3p, h\u00e3y ki\u1ec3m tra d\u1eef li\u1ec7u g\u1ed1c v\u00e0 kh\u1eafc ph\u1ee5c s\u1ef1 c\u1ed1, sau \u0111\u00f3 l\u00e0m m\u1edbi PivotTable tr\u01b0\u1edbc khi th\u1eed l\u1ea1i.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Mo_rong_cac_nhom\"><\/span><b>M\u1edf r\u1ed9ng c\u00e1c nh\u00f3m<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<figure id=\"attachment_33525\" aria-describedby=\"caption-attachment-33525\" style=\"width: 424px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-33525\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cach-nhom-du-lieu-trong-excel-pivot-table-7.jpg\" alt=\"C\u00c1CH NH\u00d3M D\u1eee LI\u1ec6U TRONG EXCEL PIVOT TABLE 7\" width=\"424\" height=\"548\" title=\"cach-nhom-du-lieu-trong-excel-pivot-table-7\"><figcaption id=\"caption-attachment-33525\" class=\"wp-caption-text\">C\u00c1CH NH\u00d3M D\u1eee LI\u1ec6U TRONG EXCEL PIVOT TABLE 7<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">M\u1ed9t l\u1ee3i \u00edch c\u1ee7a vi\u1ec7c nh\u00f3m d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n l\u00e0 b\u1ea1n c\u00f3 th\u1ec3 tr\u00edch xu\u1ea5t m\u1ed9t t\u1eadp h\u1ee3p con c\u1ee7a d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c nh\u00f3m v\u00e0o m\u1ed9t trang t\u00ednh m\u1edbi. \u0110\u1ec3 th\u1ef1c hi\u1ec7n vi\u1ec7c n\u00e0y, h\u00e3y \u0111\u1ecbnh v\u1ecb nh\u00f3m v\u00e0 nh\u1ea5p \u0111\u00fap v\u00e0o \u00f4 Total ch\u1ee9a gi\u00e1 tr\u1ecb m\u00e0 b\u1ea1n quan t\u00e2m. D\u1eef li\u1ec7u cung c\u1ea5p v\u00e0o t\u1ed5ng \u0111\u00f3 s\u1ebd \u0111\u01b0\u1ee3c tr\u00edch xu\u1ea5t sang m\u1ed9t trang t\u00ednh m\u1edbi trong c\u1eeda s\u1ed5 l\u00e0m vi\u1ec7c.<\/span><\/p>\n<p><span style=\"font-weight: 400\">B\u1ea5m \u0111\u00fap v\u00e0o b\u1ea5t k\u1ef3 gi\u00e1 tr\u1ecb n\u00e0o trong PivotTable s\u1ebd t\u1ea1o m\u1ed9t trang t\u00ednh m\u1edbi ch\u1ee9a t\u1ea5t c\u1ea3 d\u1eef li\u1ec7u \u0111\u00e3 cung c\u1ea5p v\u00e0o gi\u00e1 tr\u1ecb \u0111\u00f3.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Nhom_va_nhieu_hop_nhat_nhieu_vung_du_lieu\"><\/span><b>Nh\u00f3m v\u00e0 nhi\u1ec1u h\u1ee3p nh\u1ea5t nhi\u1ec1u v\u00f9ng d\u1eef li\u1ec7u<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">C\u0169ng c\u00f3 th\u1ec3 t\u1ea1o nh\u00f3m trong PivotTable m\u00e0 b\u1ea1n \u0111\u00e3 t\u1ea1o t\u1eeb nhi\u1ec1u v\u00f9ng d\u1eef li\u1ec7u h\u1ee3p nh\u1ea5t, ch\u1eb3ng h\u1ea1n nh\u01b0 d\u1eef li\u1ec7u tr\u00ean nhi\u1ec1u trang t\u00ednh trong c\u1eeda s\u1ed5 l\u00e0m vi\u1ec7c. \u0110\u1ec3 th\u1ef1c hi\u1ec7n vi\u1ec7c n\u00e0y trong Excel 2007 v\u00e0 2010, b\u1ea1n s\u1ebd c\u1ea7n th\u00eam c\u00f4ng c\u1ee5 PivotTable and PivotChart Wizard b\u1ecb thi\u1ebfu v\u00e0o Quick Access Toolbar (hay Ribbon trong Excel 2010).<\/span><\/p>\n<p><span style=\"font-weight: 400\">\u0110\u1ec3 th\u1ef1c hi\u1ec7n \u0111i\u1ec1u n\u00e0y, h\u00e3y nh\u1ea5p v\u00e0o n\u00fat th\u1ea3 xu\u1ed1ng c\u1ee7a thanh Quick Access Toolbar, ch\u1ecdn More Commands, t\u00ecm nh\u00f3m All Commands v\u00e0 cu\u1ed9n \u0111\u1ec3 t\u00ecm PivotTable and <a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-hien-thi-cac-doi-tuong-bi-gop-nhom-trong-pivot-table-excel.html\"><strong>PivotChart Wizard<\/strong><\/a>. Nh\u1ea5p Add \u0111\u1ec3 th\u00eam v\u00e0o Quick Access Toolbar. B\u00e2y gi\u1edd, b\u1ea1n c\u00f3 th\u1ec3 t\u1ea1o PivotTable t\u1eeb m\u1ed9t lo\u1ea1t trang t\u00ednh \u0111\u01b0\u1ee3c b\u1ed1 tr\u00ed gi\u1ed1ng nhau. B\u1ea1n s\u1ebd c\u1ea7n d\u1eef li\u1ec7u c\u00f3 c\u00f9ng s\u1ed1 v\u00e0 c\u00f9ng ti\u00eau \u0111\u1ec1 c\u1ed9t m\u1eb7c d\u00f9 m\u1ed7i trang t\u00ednh c\u00f3 th\u1ec3 ch\u1ee9a c\u00e1c s\u1ed1 h\u00e0ng d\u1eef li\u1ec7u kh\u00e1c nhau.<\/span><\/p>\n<figure id=\"attachment_33526\" aria-describedby=\"caption-attachment-33526\" style=\"width: 700px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-33526\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cach-nhom-du-lieu-trong-excel-pivot-table-8.jpg\" alt=\"C\u00c1CH NH\u00d3M D\u1eee LI\u1ec6U TRONG EXCEL PIVOT TABLE 8\" width=\"700\" height=\"549\" title=\"cach-nhom-du-lieu-trong-excel-pivot-table-8\"><figcaption id=\"caption-attachment-33526\" class=\"wp-caption-text\">C\u00c1CH NH\u00d3M D\u1eee LI\u1ec6U TRONG EXCEL PIVOT TABLE 8<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">B\u1ecf qua Excel 2010, b\u1ea1n c\u00f3 th\u1ec3 th\u00eam l\u1ea1i PivotTable and PivotChart Wizard v\u00e0o Excel b\u1eb1ng c\u00e1ch th\u00eam n\u00f3 v\u00e0o Quick Access Toolbar.<\/span><\/p>\n<p><span style=\"font-weight: 400\">\u0110\u1ec3 th\u1ef1c hi\u1ec7n vi\u1ec7c n\u00e0y, h\u00e3y th\u00eam m\u1ed9t trang t\u00ednh m\u1edbi v\u00e0o c\u1eeda s\u1ed5 l\u00e0m vi\u1ec7c c\u1ee7a b\u1ea1n, b\u1ea5m n\u00e0o n\u00fat PivotTable and PivotChart Wizard m\u1edbi c\u1ee7a bnaj v\u00e0 ch\u1ecdn Multiple Consolidation Ranges v\u00e0 PivotTable v\u00e0 b\u1ea5m Next. Ch\u1ecdn \u2018I will create the page fields\u2019 v\u00e0 nh\u1ea5n Next. B\u00e2y gi\u1edd, b\u1ea1n s\u1ebd ch\u1ecdn t\u1eebng v\u00f9ng d\u1eef li\u1ec7u, v\u00ec v\u1eady h\u00e3y chuy\u1ec3n \u0111\u1ebfn trang t\u00ednh \u0111\u1ea7u ti\u00ean v\u00e0 ch\u1ecdn t\u1ea5t c\u1ea3 d\u1eef li\u1ec7u bao g\u1ed3m c\u00e1c t\u00ean ti\u00eau \u0111\u1ec1 b\u1ea3ng v\u00e0 nh\u1ea5p v\u00e0o Add. L\u1eb7p l\u1ea1i thao t\u00e1c n\u00e0y \u0111\u1ec3 d\u1eef li\u1ec7u t\u1eeb trang t\u00ednh ti\u1ebfp theo v\u00e0 ti\u1ebfp t\u1ee5c cho \u0111\u1ebfn khi b\u1ea1n \u0111\u00e3 th\u00eam v\u00f9ng d\u1eef li\u1ec7u cho t\u1ea5t c\u1ea3 c\u00e1c trang t\u00ednh m\u00e0 b\u1ea1n mu\u1ed1n s\u1eed d\u1ee5ng PivotTable n\u00e0y.<\/span><\/p>\n<figure id=\"attachment_33527\" aria-describedby=\"caption-attachment-33527\" style=\"width: 582px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-33527\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cach-nhom-du-lieu-trong-excel-pivot-table-9.jpg\" alt=\"C\u00c1CH NH\u00d3M D\u1eee LI\u1ec6U TRONG EXCEL PIVOT TABLE 9\" width=\"582\" height=\"534\" title=\"cach-nhom-du-lieu-trong-excel-pivot-table-9\"><figcaption id=\"caption-attachment-33527\" class=\"wp-caption-text\">C\u00c1CH NH\u00d3M D\u1eee LI\u1ec6U TRONG EXCEL PIVOT TABLE 9<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">\u00a0PivotTable and PivotChart Wizard cho ph\u00e9p b\u1ea1n t\u1eadp h\u1ee3p PivotTable t\u1eeb nhi\u1ec1u v\u00f9ng d\u1eef li\u1ec7u.<\/span><\/p>\n<figure id=\"attachment_33528\" aria-describedby=\"caption-attachment-33528\" style=\"width: 692px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-33528\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cach-nhom-du-lieu-trong-excel-pivot-table-10.jpg\" alt=\"C\u00c1CH NH\u00d3M D\u1eee LI\u1ec6U TRONG EXCEL PIVOT TABLE 10\" width=\"692\" height=\"534\" title=\"cach-nhom-du-lieu-trong-excel-pivot-table-10\"><figcaption id=\"caption-attachment-33528\" class=\"wp-caption-text\">C\u00c1CH NH\u00d3M D\u1eee LI\u1ec6U TRONG EXCEL PIVOT TABLE 10<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">Trong PivotTable and PivotChart Wizard, tr\u01b0\u1edbc ti\u00ean b\u1ea1n c\u1ea7n ch\u1ecdn v\u00f9ng d\u1eef li\u1ec7u \u0111\u1ec3 s\u1eed d\u1ee5ng.<\/span><\/p>\n<p><span style=\"font-weight: 400\">Ti\u1ebfp theo, ch\u1ecdn s\u1ed1 l\u01b0\u1ee3ng trang \u0111\u1ec3 th\u00eam \u2013 th\u00f4ng th\u01b0\u1eddng b\u1ea1n s\u1ebd mu\u1ed1n m\u1ed9t ho\u1eb7c hai tr\u01b0\u1eddng. B\u00e2y gi\u1edd, b\u1ea1n h\u00e3y ch\u1ecdn t\u1eebng v\u00f9ng trong b\u1ea3ng \u1edf tr\u00ean v\u00e0 nh\u1eadp (c\u00e1c) t\u00ean nh\u00f3m \u0111\u1ec3 li\u00ean k\u1ebft v\u1edbi n\u00f3. Ch\u1ecdn v\u00f9ng ti\u1ebfp theo trong b\u1ea3ng \u0111i\u1ec1u khi\u1ec3n \u1edf tr\u00ean v\u00e0 th\u1ef1c hi\u1ec7n t\u01b0\u01a1ng t\u1ef1 v\u1edbi n\u00f3 \u2013 n\u1ebfu t\u00ean nh\u00f3m \u0111\u00e3 t\u1ed3n t\u1ea1i, b\u1ea1n c\u00f3 th\u1ec3 ch\u1ecdn n\u00f3 t\u1eeb danh s\u00e1ch th\u1ea3 xu\u1ed1ng thay v\u00ec nh\u1eadp.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-33529\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cach-nhom-du-lieu-trong-excel-pivot-table-11.jpg\" width=\"477\" height=\"534\" title=\"cach-nhom-du-lieu-trong-excel-pivot-table-11\"><\/p>\n<p><span style=\"font-weight: 400\">V\u00ec v\u1eady, v\u00ed d\u1ee5: v\u00f9ng ng\u00e0y c\u00f3 th\u1ec3 l\u00e0 m\u1ed9t ph\u1ea7n c\u1ee7a nh\u00f3m chia c\u00e1c th\u00e1ng th\u00e0nh Quarters (quy) v\u00e0 n\u00f3 c\u0169ng c\u00f3 th\u1ec3 l\u00e0 m\u1ed9t ph\u1ea7n c\u1ee7a nh\u00f3m chia c\u00e1c th\u00e0nh th\u00e0nh c\u00e1c m\u00f9a: Winter (\u0110\u00f4ng), Spring (Xu\u00e2n), Summer (H\u1ea1) v\u00e0 Fall (Thu). C\u00e1c nh\u00f3m c\u00f3 th\u1ec3 l\u00e0 b\u1ea5t k\u1ef3 th\u1ee9 g\u00ec c\u00f3 \u00fd ngh\u0129a \u0111\u1ed1i v\u1edbi b\u1ea1n \u0111\u1ec3 nh\u00f3m d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n. B\u1ea5m Next, b\u1ea5m v\u00e0o \u00f4 s\u1ebd ch\u1ee9a g\u00f3c tr\u00ean c\u00f9ng b\u00ean trai c\u1ee7a PivotTable v\u00e0 b\u1ea5m Finish.<\/span><\/p>\n<p><span style=\"font-weight: 400\">Trong PivotTable and PivotChart Wizard, b\u1ea1n c\u00f3 th\u1ec3 ch\u1ec9 \u0111\u1ecbnh v\u00f9ng cho c\u00e1c trang nh\u01b0 Quarters (Qu\u00fd) v\u00e0 Seasons (M\u00f9a) nh\u01b0 hi\u1ec3n th\u1ecb \u1edf \u0111\u00e2y.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-33530\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cach-nhom-du-lieu-trong-excel-pivot-table-12.jpg\" width=\"695\" height=\"710\" title=\"cach-nhom-du-lieu-trong-excel-pivot-table-12\"><\/p>\n<p><span style=\"font-weight: 400\">PivotTable s\u1ebd \u0111\u01b0\u1ee3c t\u1ea1o t\u1ef1 \u0111\u1ed9ng v\u00e0 c\u00e1c nh\u00f3m s\u1ebd \u0111\u01b0\u1ee3c t\u1ea1o d\u01b0\u1edbi d\u1ea1ng tr\u01b0\u1eddng Report Filter trong danh s\u00e1ch Field m\u1eb7c d\u00f9 b\u1ea1n c\u00f3 th\u1ec3 k\u00e9o c\u00e1c tr\u01b0\u1eddng v\u00e0o b\u1ea3ng Labels hay Column Labels n\u1ebfu mu\u1ed1n.<\/span><\/p>\n<p><span style=\"font-weight: 400\">\u1ede \u0111\u00e2y, ch\u00fang t\u00f4i \u0111\u00e3 chuy\u1ec3n tr\u00e0n Report Filter th\u00e0nh Row Label.<\/span><\/p>\n<p><span style=\"font-weight: 400\">Cho d\u00f9 b\u1ea1n nh\u00f3m d\u1eef li\u1ec7u trong PivotTable \u0111\u00e3 \u0111\u01b0\u1ee3c t\u1ea1o hay b\u1ea1n t\u1ea1o ch\u00fang t\u1ea1i th\u1eddi \u0111i\u1ec3m t\u1ea1o PivotTable t\u1eeb nhi\u1ec1u v\u00f9ng d\u1eef li\u1ec7u, k\u1ebft qu\u1ea3 l\u00e0 gi\u1ed1ng nhau v\u00e0 b\u1ea1n c\u00f3 m\u1ed9t c\u00f4ng c\u1ee5 kh\u00e1c trong b\u1ed9 c\u00f4ng c\u1ee5 \u0111\u1ec3 t\u1ed1i gi\u1ea3n d\u1eef li\u1ec7u trong Excel PivotTable.\u00a0\u00a0<\/span><\/p>\n<h1><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-33531\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cach-nhom-du-lieu-trong-excel-pivot-table-13.jpg\" width=\"561\" height=\"559\" title=\"cach-nhom-du-lieu-trong-excel-pivot-table-13\"><\/h1>\n<p>Hy v\u1ecdng v\u1edbi nh\u1eefng chia s\u1ebb tr\u00ean, <strong>H\u1ecdc Excel Online<\/strong> s\u1ebd gi\u00fap b\u1ea1n gi\u1ea3i quy\u1ebft m\u1ed9t s\u1ed1 v\u1ea5n \u0111\u1ec1 g\u1eb7p ph\u1ea3i khi h\u1ecdc t\u1eadp, l\u00e0m vi\u1ec7c. H\u00e3y tham gia c\u00f9ng H\u1ecdc Excel Online v\u00e0o c\u00e1c kh\u00f3a h\u1ecdc Excel tr\u1ef1c tuy\u1ebfn linh ho\u1ea1t v\u1edbi nh\u1eefng b\u00e0i gi\u1ea3ng chuy\u00ean s\u00e2u. <strong>H\u1ecdc Excel Online<\/strong> lu\u00f4n t\u1ef1 h\u00e0o l\u00e0 trang web tr\u1ef1c tuy\u1ebfn cung c\u00e1c c\u00e1c kh\u00f3a h\u1ecdc excel h\u00e0ng \u0111\u1ea7u t\u1eeb c\u00e1c chuy\u00ean gia d\u00e0y d\u1eb7n kinh nghi\u1ec7m. Tham gia ng\u00e0y t\u1eeb h\u00f4m nay \u0111\u1ec3 nh\u1eadn ngay nh\u1eefng \u01b0u \u0111\u00e3i \u0111\u1eb7c bi\u1ec7t nh\u00e9! <a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc-excel-tu-co-ban-toi-nang-cao-danh-cho-dan-van-phong-2010-20132016\"><strong>\u0110\u0103ng k\u00fd kh\u00f3a h\u1ecdc Excel<\/strong> <\/a>t\u1eeb c\u00f3 b\u1ea3n \u0111\u1ebfn n\u00e2ng cao t\u1ea1i \u0111\u00e2y!<\/p>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<p>D\u00f9 \u0111\u00e3 c\u00f3 ph\u1ea7n m\u1ec1m, nh\u01b0ng k\u1ef9 n\u0103ng Excel v\u1eabn c\u1ef1c k\u1ef3 quan tr\u1ecdng v\u1edbi k\u1ebf to\u00e1n, b\u1ea1n \u0111\u00e3 v\u1eefng Excel ch\u01b0a? H\u00e3y \u0111\u1ec3 t\u00f4i gi\u00fap b\u1ea1n, \u0111\u0103ng k\u00fd kho\u00e1 h\u1ecdc Excel:<\/p>\n<p><a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-170.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":2225,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-2224","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-nang-cao"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/2224","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/comments?post=2224"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/2224\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/2225"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=2224"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=2224"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=2224"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}