{"id":10307,"date":"2025-01-13T10:05:12","date_gmt":"2025-01-13T10:05:12","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/13\/huong-dan-cach-lap-bao-cao-theo-nhieu-dieu-kien-bang-pivot-table\/"},"modified":"2025-01-13T10:05:12","modified_gmt":"2025-01-13T10:05:12","slug":"huong-dan-cach-lap-bao-cao-theo-nhieu-dieu-kien-bang-pivot-table","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/13\/huong-dan-cach-lap-bao-cao-theo-nhieu-dieu-kien-bang-pivot-table\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch l\u1eadp b\u00e1o c\u00e1o theo nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n b\u1eb1ng Pivot Table"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>H\u00e0ng ng\u00e0y ch\u00fang ta th\u01b0\u1eddng ph\u1ea3i m\u1ea5t nhi\u1ec1u th\u1eddi gian cho vi\u1ec7c l\u1eadp b\u00e1o c\u00e1o. Chuy\u1ec7n s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c \u0111\u1ec3 l\u1eadp b\u00e1o c\u00e1o h\u1eb3n khi\u1ebfn b\u1ea1n th\u1ea5y m\u1ec7t m\u1ecfi v\u00e0 kh\u00f3 ch\u1ecbu, khi ch\u1ec9 m\u1ed9t sai s\u00f3t nh\u1ecf trong c\u00f4ng th\u1ee9c c\u0169ng khi\u1ebfn b\u00e1o c\u00e1o kh\u00f4ng ra k\u1ebft qu\u1ea3 nh\u01b0 \u00fd mu\u1ed1n. V\u1eady sao kh\u00f4ng th\u1eed m\u1ed9t c\u00e1ch kh\u00e1c, c\u00e1ch l\u1eadp b\u00e1o c\u00e1o kh\u00f4ng c\u1ea7n d\u00f9ng c\u00f4ng th\u1ee9c? H\u00e3y c\u00f9ng H\u1ecdc Excel Online t\u00ecm hi\u1ec3u\u00a0c\u00e1ch l\u1eadp b\u00e1o c\u00e1o theo nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n b\u1eb1ng Pivot Table nh\u00e9.<\/p>\n<p>Nh\u1eafc t\u1edbi b\u00e1o c\u00e1o theo nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n, ch\u00fang ta th\u01b0\u1eddng ngh\u0129 t\u1edbi b\u00e1o c\u00e1o c\u00f3 c\u1ea5u tr\u00fac ph\u1ee9c t\u1ea1p, kh\u00f3 \u0111\u1ec3 tr\u00ecnh b\u00e0y sao cho khoa h\u1ecdc, h\u1ee3p l\u00fd c\u00e1c \u0111i\u1ec1u ki\u1ec7n. V\u1eady h\u00e3y nh\u1edb l\u1ea1i 3 c\u1ea5u tr\u00fac b\u00e1o c\u00e1o t\u1ed5ng h\u1ee3p theo 3 m\u1ee9c \u0111i\u1ec1u ki\u1ec7n nh\u00e9:<\/p>\n<p>T\u00ecm hi\u1ec3u b\u00e0i vi\u1ebft:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/tim-hieu-ve-cac-dang-bao-cao-thuong-gap-tren-excel.html\">T\u00ecm hi\u1ec3u v\u1ec1 c\u00e1c d\u1ea1ng b\u00e1o c\u00e1o th\u01b0\u1eddng g\u1eb7p tr\u00ean Excel<\/a><\/p>\n<p>H\u00e3y t\u00ecm hi\u1ec3u c\u00e1ch l\u1eadp b\u00e1o c\u00e1o th\u00f4ng qua v\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<p>Cho b\u1ea3ng d\u1eef li\u1ec7u g\u1ed3m 6 c\u1ed9t v\u00e0 g\u1ea7n 200 d\u00f2ng d\u1eef li\u1ec7u. H\u00e3y l\u1eadp b\u00e1o c\u00e1o\u00a0\u00a0theo t\u1eebng <strong>m\u00e3 hi\u1ec7u<\/strong> c\u1ee7a <strong>kh\u00e1ch h\u00e0ng Doanh nghi\u1ec7p<\/strong>, trong <strong>ch\u01b0\u01a1ng tr\u00ecnh ti\u1ebft ki\u1ec7m<\/strong> c\u1ee7a <strong>chi nh\u00e1nh 2<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-20237\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/data-pivot-table-ngan-hang.png\" width=\"812\" height=\"326\" title=\"data-pivot-table-ngan-hang\"><\/p>\n<p>Y\u00eau c\u1ea7u kh\u00e1 ph\u1ee9c t\u1ea1p ph\u1ea3i kh\u00f4ng n\u00e0o. H\u00e3y xem ch\u00fang ta s\u1ebd b\u00e1o c\u00e1o theo y\u00eau c\u1ea7u n\u00e0y tr\u00ean Pivot Table th\u1ebf n\u00e0o nh\u00e9.<\/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<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\/2025\/01\/ex101_92019-nho-154.gif\" title=\"ex101_92019-nho-154\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><label for=\"ez-toc-cssicon-toggle-item-6784e5572e7cb\" 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\/huong-dan-cach-lap-bao-cao-theo-nhieu-dieu-kien-bang-pivot-table.html#Phan_tich_yeu_cau_va_dinh_hinh_cau_truc_bao_cao\" title=\"Ph\u00e2n t\u00edch y\u00eau c\u1ea7u v\u00e0 \u0111\u1ecbnh h\u00ecnh c\u1ea5u tr\u00fac b\u00e1o c\u00e1o\">Ph\u00e2n t\u00edch y\u00eau c\u1ea7u v\u00e0 \u0111\u1ecbnh h\u00ecnh c\u1ea5u tr\u00fac b\u00e1o c\u00e1o<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-lap-bao-cao-theo-nhieu-dieu-kien-bang-pivot-table.html#Xet_cac_doi_tuong_co_lien_quan_toi_bao_cao\" title=\"X\u00e9t c\u00e1c \u0111\u1ed1i t\u01b0\u1ee3ng c\u00f3 li\u00ean quan t\u1edbi b\u00e1o c\u00e1o:\">X\u00e9t c\u00e1c \u0111\u1ed1i t\u01b0\u1ee3ng c\u00f3 li\u00ean quan t\u1edbi b\u00e1o c\u00e1o:<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-lap-bao-cao-theo-nhieu-dieu-kien-bang-pivot-table.html#Xac_dinh_moi_quan_he_cua_cac_doi_tuong\" title=\"X\u00e1c \u0111\u1ecbnh m\u1ed1i quan h\u1ec7 c\u1ee7a c\u00e1c \u0111\u1ed1i t\u01b0\u1ee3ng\">X\u00e1c \u0111\u1ecbnh m\u1ed1i quan h\u1ec7 c\u1ee7a c\u00e1c \u0111\u1ed1i t\u01b0\u1ee3ng<\/a><\/li>\n<\/ul>\n<\/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\/huong-dan-cach-lap-bao-cao-theo-nhieu-dieu-kien-bang-pivot-table.html#Cach_su_dung_Pivot_Table_de_lap_bao_cao\" title=\"C\u00e1ch s\u1eed d\u1ee5ng Pivot Table \u0111\u1ec3 l\u1eadp b\u00e1o c\u00e1o\">C\u00e1ch s\u1eed d\u1ee5ng Pivot Table \u0111\u1ec3 l\u1eadp b\u00e1o c\u00e1o<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Phan_tich_yeu_cau_va_dinh_hinh_cau_truc_bao_cao\"><\/span>Ph\u00e2n t\u00edch y\u00eau c\u1ea7u v\u00e0 \u0111\u1ecbnh h\u00ecnh c\u1ea5u tr\u00fac b\u00e1o c\u00e1o<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Kh\u00f4ng ch\u1ec9 t\u1edbi khi l\u00e0m b\u00e1o c\u00e1o tr\u00ean PivotTable m\u1edbi l\u00e0m b\u01b0\u1edbc n\u00e0y, m\u00e0 b\u1ea1n c\u1ea7n l\u00e0m m\u1ed7i khi g\u1eb7p ph\u1ea3i y\u00eau c\u1ea7u b\u00e1o c\u00e1o. Vi\u1ec7c ph\u00e2n t\u00edch y\u00eau c\u1ea7u s\u1ebd gi\u00fap ch\u00fang ta nh\u1eadn ra m\u1ee5c ti\u00eau c\u1ee7a b\u00e1o c\u00e1o, c\u00e1c \u0111\u1ed1i t\u01b0\u1ee3ng c\u00f3 li\u00ean quan t\u1edbi b\u00e1o c\u00e1o. T\u1eeb \u0111\u00f3 ch\u00fang ta s\u1ebd c\u00f3 th\u1ec3 h\u00ecnh dung, \u0111\u1ecbnh h\u00ecnh \u0111\u01b0\u1ee3c c\u1ea5u tr\u00fac c\u1ee7a b\u1ea3ng b\u00e1o c\u00e1o. \u0110\u00e2y l\u00e0 m\u1ed9t b\u01b0\u1edbc r\u1ea5t quan tr\u1ecdng, mang t\u00ednh quy\u1ebft \u0111\u1ecbnh cho vi\u1ec7c b\u00e1o c\u00e1o \u0111\u00fang hay sai, khoa h\u1ecdc hay kh\u00f4ng.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Xet_cac_doi_tuong_co_lien_quan_toi_bao_cao\"><\/span>X\u00e9t c\u00e1c \u0111\u1ed1i t\u01b0\u1ee3ng c\u00f3 li\u00ean quan t\u1edbi b\u00e1o c\u00e1o:<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ul>\n<li>B\u00e1o c\u00e1o theo m\u00e3 hi\u1ec7u: c\u00f3 li\u00ean quan t\u1edbi <strong>c\u1ed9t m\u00e3 hi\u1ec7u<\/strong>, l\u1ecdc ra <strong>nh\u1eefng m\u00e3 hi\u1ec7u c\u1ee7a kh\u00e1ch h\u00e0ng l\u00e0 Doanh nghi\u1ec7p<\/strong><\/li>\n<li>B\u00e1o c\u00e1o theo kh\u00e1ch h\u00e0ng l\u00e0 doanh nghi\u1ec7p: Trong <strong>c\u1ed9t Kh\u00e1ch h\u00e0ng<\/strong>, ch\u1ec9 x\u00e9t nh\u1eefng \u0111\u1ed1i t\u01b0\u1ee3ng l\u00e0 <strong>Doanh nghi\u1ec7p<\/strong><\/li>\n<li>B\u00e1o c\u00e1o theo ch\u01b0\u01a1ng tr\u00ecnh l\u00e0 ti\u1ebft ki\u1ec7m: Trong<strong> c\u1ed9t Ch\u01b0\u01a1ng tr\u00ecnh<\/strong>, ch\u1ec9 x\u00e9t nh\u1eefng \u0111\u1ed1i t\u01b0\u1ee3ng l\u00e0 <strong>Ti\u1ebft ki\u1ec7m<\/strong><\/li>\n<li>B\u00e1o c\u00e1o theo chi nh\u00e1nh 2: Trong <strong>c\u1ed9t Chi nh\u00e1nh<\/strong>, ch\u1ec9 x\u00e9t nh\u1eefng \u0111\u1ed1i t\u01b0\u1ee3ng l\u00e0 <strong>CN2<\/strong><\/li>\n<li>K\u1ebft qu\u1ea3 c\u1ea7n t\u00ednh to\u00e1n, b\u00e1o c\u00e1o l\u00e0 S\u1ed1 ti\u1ec1n<\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"Xac_dinh_moi_quan_he_cua_cac_doi_tuong\"><\/span>X\u00e1c \u0111\u1ecbnh m\u1ed1i quan h\u1ec7 c\u1ee7a c\u00e1c \u0111\u1ed1i t\u01b0\u1ee3ng<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Vi\u1ec7c x\u00e1c \u0111\u1ecbnh m\u1ed1i quan h\u1ec7 c\u1ee7a c\u00e1c \u0111\u1ed1i t\u01b0\u1ee3ng s\u1ebd gi\u00fap ch\u00fang ta c\u00f3 th\u1ec3 x\u00e2y d\u1ef1ng b\u1ed1 c\u1ee5c c\u1ee7a b\u1ea3ng b\u00e1o c\u00e1o.<\/p>\n<ul>\n<li><strong>M\u00e3 hi\u1ec7u v\u00e0 Kh\u00e1ch h\u00e0ng<\/strong>: 2 tr\u01b0\u1eddng d\u1eef li\u1ec7u n\u00e0y c\u00f3 li\u00ean quan t\u1edbi nhau. Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y Kh\u00e1ch h\u00e0ng l\u00e0 \u0111\u1ed1i t\u01b0\u1ee3ng t\u1ed5ng qu\u00e1t, theo nh\u00f3m, M\u00e3 hi\u1ec7u l\u00e0 \u0111\u1ed1i t\u01b0\u1ee3ng chi ti\u1ebft, theo t\u1eebng m\u00e3. Khi b\u1ed1 c\u1ee5c\u00a0trong b\u00e1o c\u00e1o th\u00ec 2 n\u1ed9i dung n\u00e0y ph\u1ea3i n\u1eb1m tr\u00ean c\u00f9ng 1 m\u1ee5c\u00a0(1 chi\u1ec1u b\u00e1o c\u00e1o)<\/li>\n<li><strong>Ch\u01b0\u01a1ng tr\u00ecnh<\/strong>: Ch\u01b0\u01a1ng tr\u00ecnh kh\u00f4ng ph\u1ee5 thu\u1ed9c v\u00e0o \u0111\u1ed1i t\u01b0\u1ee3ng n\u00e0o, do \u0111\u00f3 s\u1ebd n\u1eb1m tr\u00ean 1 m\u1ee5c (1 chi\u1ec1u b\u00e1o c\u00e1o). N\u1ebfu M\u00e3 hi\u1ec7u v\u00e0 Kh\u00e1ch h\u00e0ng n\u1eb1m tr\u00ean chi\u1ec1u Theo d\u00f2ng th\u00ec ch\u01b0\u01a1ng tr\u00ecnh s\u1ebd n\u1eb1m tr\u00ean chi\u1ec1u Theo c\u1ed9t (ho\u1eb7c ng\u01b0\u1ee3c l\u1ea1i)<\/li>\n<li><strong>Chi nh\u00e1nh<\/strong>: \u0110\u1ed1i t\u01b0\u1ee3ng n\u00e0y c\u0169ng \u0111\u00f3ng vai tr\u00f2 \u0111\u1ed9c l\u1eadp, n\u00ean c\u00f3 th\u1ec3 \u0111\u1eb7t \u1edf chi\u1ec1u th\u1ee9 3 c\u1ee7a b\u00e1o c\u00e1o<\/li>\n<li><strong>S\u1ed1 ti\u1ec1n<\/strong>: \u0110\u00e2y l\u00e0 k\u1ebft qu\u1ea3 c\u1ea7n t\u00ednh c\u1ee7a b\u00e1o c\u00e1o. K\u1ebft qu\u1ea3 s\u1ebd x\u00e1c \u0111\u1ecbnh t\u1ea1i v\u1ecb tr\u00ed giao \u0111i\u1ec3m c\u1ee7a c\u00e1c chi\u1ec1u b\u00e1o c\u00e1o.<\/li>\n<\/ul>\n<p>Nh\u01b0 v\u1eady ch\u00fang ta c\u00f3 th\u1ec3 h\u00ecnh dung 1 v\u00e0i b\u1ed1 c\u1ee5c b\u00e1o c\u00e1o c\u00f3 th\u1ec3 x\u00e2y d\u1ef1ng nh\u01b0 sau:<\/p>\n<p><strong>D\u1ea1ng th\u1ee9 1<\/strong>: B\u1ed1 c\u1ee5c theo chi\u1ec1u d\u1ecdc.\u00a0\u1ede d\u1ea1ng n\u00e0y s\u1ed1 l\u01b0\u1ee3ng c\u1ed9t \u00edt h\u01a1n s\u1ed1 l\u01b0\u1ee3ng d\u00f2ng. C\u0103n c\u1ee9 theo\u00a0tr\u01b0\u1eddng d\u1eef li\u1ec7u n\u00e0o c\u00f3 nhi\u1ec1u n\u1ed9i dung s\u1ebd s\u1eafp x\u1ebfp tr\u00ean c\u00e1c d\u00f2ng.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-20430\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/bao-cao-dang-01-mau-pivot.png\" width=\"389\" height=\"189\" title=\"bao-cao-dang-01-mau-pivot\"><\/p>\n<p><strong>D\u1ea1ng th\u1ee9 2<\/strong>: B\u1ed1 c\u1ee5c theo chi\u1ec1u ngang. \u1ede d\u1ea1ng n\u00e0y s\u1ed1 l\u01b0\u1ee3ng c\u1ed9t nhi\u1ec1u h\u01a1n s\u1ed1 l\u01b0\u1ee3ng d\u00f2ng.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-20431\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/bao-cao-dang-02-mau-pivot.png\" width=\"534\" height=\"132\" title=\"bao-cao-dang-02-mau-pivot\"><\/p>\n<p>Th\u00f4ng th\u01b0\u1eddng ch\u00fang ta hay ch\u1ecdn b\u00e1o c\u00e1o theo d\u1ea1ng th\u1ee9 1. B\u1edfi trong Excel \u01b0u ti\u00ean c\u00e1c c\u1ea5u tr\u00fac theo chi\u1ec1u d\u1ecdc.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cach_su_dung_Pivot_Table_de_lap_bao_cao\"><\/span>C\u00e1ch s\u1eed d\u1ee5ng Pivot Table \u0111\u1ec3 l\u1eadp b\u00e1o c\u00e1o<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Trong b\u00e0i t\u1eadp n\u00e0y, ch\u00fang ta c\u00f3 th\u1ec3 l\u00e0m nh\u01b0 sau:<\/p>\n<p><strong>B\u01b0\u1edbc 1:<\/strong>\u00a0ch\u1ecdn to\u00e0n b\u1ed9 b\u1ea3ng d\u1eef li\u1ec7u b\u1eb1ng c\u00e1ch ch\u1ecdn 1 v\u1ecb tr\u00ed b\u1ea5t k\u1ef3 trong b\u1ea3ng d\u1eef li\u1ec7u r\u1ed3i b\u1ea5m ph\u00edm t\u1eaft Ctrl + * (ph\u00edm ctrl v\u00e0 ph\u00edm d\u1ea5u *)<\/p>\n<p><strong>B\u01b0\u1edbc 2:<\/strong>\u00a0trong th\u1ebb Insert ch\u1ecdn Pivot Table. Ch\u1ecdn n\u01a1i \u0111\u1eb7t Pivot table l\u00e0 1 sheet m\u1edbi (ch\u1ecdn New Worksheet)<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-20432\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/insert-pivottable-new-workbook.png\" width=\"584\" height=\"672\" title=\"insert-pivottable-new-workbook\"><\/p>\n<p><strong>B\u01b0\u1edbc 3:<\/strong>\u00a0x\u00e1c \u0111\u1ecbnh c\u00e1c th\u00e0nh ph\u1ea7n trong b\u00e1o c\u00e1o b\u1eb1ng Pivot table<\/p>\n<p>\u0110\u1ec3 th\u1ef1c hi\u1ec7n b\u01b0\u1edbc n\u00e0y, ch\u00fang ta ph\u1ea3i c\u0103n c\u1ee9 v\u00e0o c\u00e1c y\u00eau c\u1ea7u c\u1ee7a b\u00e1o c\u00e1o:<\/p>\n<ul>\n<li>T\u1eebng m\u00e3 hi\u1ec7u c\u1ee7a kh\u00e1ch h\u00e0ng l\u00e0 kh\u00e1ch l\u1ebb =&gt; Trong\u00a0<strong>Rows<\/strong>\u00a0\u0111\u1eb7t 2 tr\u01b0\u1eddng\u00a0<strong>M\u00e3 hi\u1ec7u v\u00e0 Kh\u00e1ch h\u00e0ng<\/strong><\/li>\n<li>Ch\u01b0\u01a1ng tr\u00ecnh l\u00e0 Ti\u1ebft ki\u1ec7m =&gt; Trong\u00a0<strong>Columns<\/strong>\u00a0\u0111\u1eb7t tr\u01b0\u1eddng\u00a0<strong>Ch\u01b0\u01a1ng tr\u00ecnh<\/strong><\/li>\n<li>Chi nh\u00e1nh 2 =&gt; Trong\u00a0<strong>Filters<\/strong>\u00a0\u0111\u1eb7t tr\u01b0\u1eddng\u00a0<strong>Chi nh\u00e1nh<\/strong><\/li>\n<li>K\u1ebft qu\u1ea3 b\u00e1o c\u00e1o l\u00e0 s\u1ed1 ti\u1ec1n =&gt; Trong\u00a0<strong>Values<\/strong>\u00a0\u0111\u1eb7t tr\u01b0\u1eddng\u00a0<strong>S\u1ed1 ti\u1ec1n<\/strong>.<\/li>\n<\/ul>\n<p>K\u1ebft qu\u1ea3 b\u00e1o c\u00e1o nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-20380\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/tao-bang-pivot-table-theo-3-dk.png\" width=\"933\" height=\"648\" title=\"tao-bang-pivot-table-theo-3-dk\"><\/p>\n<p>Sau khi t\u1ea1o ra Pivot Table, ch\u00fang ta th\u1ef1c hi\u1ec7n l\u1ecdc c\u00e1c \u0111\u1ed1i t\u01b0\u1ee3ng c\u1ee7a b\u00e1o c\u00e1o \u0111\u1ec3 ph\u00f9 h\u1ee3p v\u1edbi y\u00eau c\u1ea7u b\u00e1o c\u00e1o:<\/p>\n<ul>\n<li>Chi nh\u00e1nh: Ch\u1ecdn chi nh\u00e1nh 2<\/li>\n<li>Kh\u00e1ch h\u00e0ng: Ch\u1ecdn Doanh nghi\u1ec7p<\/li>\n<li>Ch\u01b0\u01a1ng tr\u00ecnh: Ch\u1ecdn Ti\u1ebft ki\u1ec7m<\/li>\n<\/ul>\n<p>K\u1ebft qu\u1ea3 nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-20381\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/loc-ket-qua-bao-cao-pivot-table.png\" width=\"508\" height=\"426\" title=\"loc-ket-qua-bao-cao-pivot-table\"><\/p>\n<p>C\u00e1c b\u1ea1n c\u00f3 th\u1ec3 t\u1ea3i v\u1ec1 file m\u1eabu t\u1ea1i \u0111\u1ecba ch\u1ec9:\u00a0<a href=\"http:\/\/bit.ly\/2LAdJKq\">http:\/\/bit.ly\/2LAdJKq<\/a><\/p>\n<p>Nh\u01b0 v\u1eady ch\u1ec9 v\u1edbi m\u1ed9t v\u00e0i thao t\u00e1c k\u00e9o th\u1ea3 v\u00e0 l\u1ecdc \u0111\u1ed1i t\u01b0\u1ee3ng, ch\u00fang ta \u0111\u00e3 c\u00f3 th\u1ec3 ho\u00e0n th\u00e0nh b\u00e1o c\u00e1o m\u1ed9t c\u00e1ch nhanh ch\u00f3ng v\u00e0 ti\u1ec7n l\u1ee3i. Ch\u00ednh v\u00ec v\u1eady Pivot Table tr\u1edf th\u00e0nh 1 c\u00f4ng c\u1ee5 r\u1ea5t h\u1eefu \u00edch trong vi\u1ec7c l\u1eadp b\u00e1o c\u00e1o trong Excel.<\/p>\n<p>Xem th\u00eam:<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/cach-lap-bao-cao-theo-thang-bang-pivot-table-khi-du-lieu-khong-co-san-cot-thang.html\">C\u00e1ch l\u1eadp b\u00e1o c\u00e1o theo th\u00e1ng b\u1eb1ng pivot table khi d\u1eef li\u1ec7u kh\u00f4ng c\u00f3 s\u1eb5n c\u1ed9t th\u00e1ng<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/cach-lap-bao-cao-ty-le-phan-tram-trong-excel-bang-pivot-table-don-gian-nhat.html\">C\u00e1ch l\u1eadp b\u00e1o c\u00e1o t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m trong excel b\u1eb1ng Pivot table \u0111\u01a1n gi\u1ea3n nh\u1ea5t<\/a><\/p>\n<p>\u0110\u1ec3 t\u00ecm hi\u1ec3u th\u00eam nh\u1eefng ki\u1ebfn th\u1ee9c v\u1ec1 Excel v\u00e0 Pivot table, c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 tham gia kh\u00f3a h\u1ecdc <a href=\"http:\/\/bit.ly\/2NZ9RUW\">EX101 \u2013 Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi chuy\u00ean gia<\/a>. \u0110\u00e2y l\u00e0 kh\u00f3a h\u1ecdc cung c\u1ea5p cho b\u1ea1n ki\u1ebfn th\u1ee9c \u0111\u1ea7y \u0111\u1ee7 v\u00e0 c\u00f3 h\u1ec7 th\u1ed1ng v\u1ec1 c\u00e1c h\u00e0m trong Excel, c\u00e1ch s\u1eed d\u1ee5ng c\u00e1c c\u00f4ng c\u1ee5 trong Excel, \u1ee9ng d\u1ee5ng Excel v\u00e0o c\u00f4ng vi\u1ec7c m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3. H\u00e3y tham gia ngay \u0111\u1ec3 nh\u1eadn \u0111\u01b0\u1ee3c nh\u1eefng \u01b0u \u0111\u00e3i t\u1eeb h\u1ec7 th\u1ed1ng. Chi ti\u1ebft xem t\u1ea1i:<\/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<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\/2025\/01\/ex101_92019-nho-154.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":10308,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-10307","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-co-ban"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/10307","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=10307"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/10307\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/10308"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=10307"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=10307"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=10307"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}