{"id":11167,"date":"2025-01-15T01:54:38","date_gmt":"2025-01-15T01:54:38","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/cach-sap-xep-mot-pivot-table-trong-excel\/"},"modified":"2025-01-15T01:54:38","modified_gmt":"2025-01-15T01:54:38","slug":"cach-sap-xep-mot-pivot-table-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/cach-sap-xep-mot-pivot-table-trong-excel\/","title":{"rendered":"C\u00e1ch s\u1eafp x\u1ebfp m\u1ed9t Pivot Table trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\">B\u1ea1n c\u00f3 th\u1ec3 <a href=\"http:\/\/blog.ezworkapp.com\/cach-sap-xep-mot-pivot-table-trong-excel.html\">s\u1eafp x\u1ebfp m\u1ed9t pivot table trong Excel<\/a> theo chi\u1ec1u d\u1ecdc ho\u1eb7c chi\u1ec1u ngang. \u0110i\u1ec1u n\u00e0y gi\u00fap cho b\u1ea1n c\u00f3 th\u1ec3 nhanh ch\u00f3ng nh\u1eadn ra \u0111\u01b0\u1ee3c nh\u1eefng h\u00e0ng ho\u1eb7c c\u1ed9t ch\u1ee9a gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t ho\u1eb7c nh\u1ecf nh\u1ea5t.<\/p>\n<p style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/cach-sap-xep-mot-pivot-table-trong-excel.html\">C\u00e1ch \u0111\u01a1n gi\u1ea3n nh\u1ea5t \u0111\u1ec3 s\u1eafp x\u1ebfp pivot table<\/a> l\u00e0 ch\u1ecdn ra \u00f4 b\u1ea1n mu\u1ed1n s\u1eafp x\u1ebfp trong m\u1ed9t h\u00e0ng ho\u1eb7c c\u1ed9t nh\u1ea5t \u0111\u1ecbnh r\u1ed3i sau \u0111\u00f3 ch\u1ecdn l\u1ec7nh\u00a0<strong>Sort Ascending<\/strong> (t\u0103ng d\u1ea7n) ho\u1eb7c <strong>Sort Descending<\/strong> (gi\u1ea3m d\u1ea7n):<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-8521 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/sort_buttons.png\" width=\"125\" height=\"52\" title=\"sort_buttons\"><\/p>\n<p style=\"text-align: justify\">L\u1ec7nh\u00a0\u2018<strong>Sort Ascending<\/strong>\u2018 v\u00e0 \u2018<strong>Sort Descending<\/strong>\u2018 \u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n nh\u01b0 sau:<\/p>\n<ul style=\"text-align: justify\">\n<li>Trong b\u1ea3n Excel hi\u1ec7n h\u00e0nh: Nh\u1ea5n chu\u1ed9t ph\u1ea3i v\u00e0o pivot table v\u00e0 ch\u1ecdn \u2018<strong>Sort<\/strong>\u2018 ho\u1eb7c l\u1ec7nh n\u1eb1m trong nh\u00f3m\u00a0\u2018<strong>Sort<\/strong> <strong>&amp; Filter<\/strong>\u2018c\u1ee7a nh\u00e3n \u2018<strong>Data<\/strong>\u2018.<\/li>\n<li>Trong b\u1ea3n Excel 2003: Trong nh\u00e3n \u2018<strong>Standard<\/strong>\u2018 tr\u00ean thanh c\u00f4ng c\u1ee5 ho\u1eb7c t\u1ea1i menu \u2018<strong>Data<\/strong>\u2018 ch\u1ecdn\u00a0\u2018<strong>Sort\u2026<\/strong>\u2018<\/li>\n<\/ul>\n<p style=\"text-align: justify\"><strong>V\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y s\u1ebd gi\u00fap b\u1ea1n d\u1ec5 d\u00e0ng h\u00ecnh dung ra c\u00e1ch s\u1eafp x\u1ebfp m\u1ed9t Pivot Table:<\/strong><\/p>\n<p style=\"text-align: justify\">B\u1ea3ng b\u00ean d\u01b0\u1edbi bi\u1ec3u di\u1ec5n doanh thu c\u1ee7a m\u1ed9t c\u00f4ng ty, \u0111\u01b0\u1ee3c chia nh\u1ecf theo th\u00e1ng v\u00e0 ng\u01b0\u1eddi b\u00e1n h\u00e0ng<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-8522 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/1-300x289-1.png\" width=\"300\" height=\"289\" title=\"1-300x289-1\"><\/p>\n<ul style=\"text-align: justify\">\n<li>S\u1eafp x\u1ebfp Pivot Table theo m\u1ed9t c\u1ed9t<\/li>\n<\/ul>\n<p style=\"text-align: justify\">H\u00ecnh dung b\u1ea1n mu\u1ed1n s\u1eafp x\u1ebfp c\u00e1c th\u00e1ng, \u0111\u1ec3 th\u00e1ng ghi nh\u1eadn doanh thu\u00a0l\u1edbn nh\u1ea5t trong n\u0103m x\u1ebfp l\u00ean \u0111\u1ea7u ti\u00ean. \u0110\u1ec3 th\u1ef1c hi\u1ec7n c\u00f4ng vi\u1ec7c n\u00e0y, b\u1ea1n l\u00e0m nh\u01b0 sau:<\/p>\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\/2025\/01\/vba101_92019-nho-33.gif\" title=\"vba101_92019-nho-33\"><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\/2025\/01\/ex101_92019-nho-265.gif\" title=\"ex101_92019-nho-265\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<ol style=\"text-align: justify\">\n<li>Nh\u1ea5n chu\u1ed9t v\u00e0o b\u1ea5t k\u00ec gi\u00e1 tr\u1ecb n\u00e0o trong c\u1ed9t\u00a0\u2018<strong>Grand Total<\/strong>\u2018 .<\/li>\n<li>Th\u1ef1c hi\u1ec7n l\u1ec7nh\u00a0\u2018<strong>Sort Descending<\/strong>\u2018.<\/li>\n<\/ol>\n<p style=\"text-align: justify\">Sau \u0111\u00f3 b\u1ea1n s\u1ebd \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 nh\u01b0 h\u00ecnh b\u00ean d\u01b0\u1edbi: th\u00e1ng 6 (Jun) \u0111\u01b0\u1ee3c x\u1ebfp l\u00ean \u0111\u1ea7u ti\u00ean v\u1edbi doanh thu l\u1edbn nh\u1ea5t, theo sau l\u00e0 th\u00e1ng 1 (Jan) v\u00e0 gi\u1ea3m d\u1ea7n.<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-8523 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/2-1-300x289-1.png\" width=\"300\" height=\"289\" title=\"2-1-300x289-1\"><\/p>\n<ul style=\"text-align: justify\">\n<li>S\u1eafp x\u1ebfp Pivot Table theo m\u1ed9t h\u00e0ng<\/li>\n<\/ul>\n<p style=\"text-align: justify\">T\u01b0\u01a1ng t\u1ef1 nh\u01b0 x\u1ebfp theo c\u1ed9t, \u0111\u1ec3 s\u1eafp x\u1ebfp pivot table theo h\u00e0ng, c\u0169ng trong v\u00ed d\u1ee5 tr\u00ean, b\u1ea1n th\u1ef1c hi\u1ec7n:<\/p>\n<ol style=\"text-align: justify\">\n<li>Nh\u1ea5n chu\u1ed9t ph\u1ea3i v\u00e0o b\u1ea5t k\u00ec gi\u00e1 tr\u1ecb n\u00e0o trong h\u00e0ng\u00a0\u2018<strong>Grand Total<\/strong>\u2018 (\u00f4 B17 ho\u1eb7c C17 trong b\u1ea3ng t\u00ednh \u1edf v\u00ed d\u1ee5 tr\u00ean)<\/li>\n<li>Th\u1ef1c hi\u1ec7n l\u1ec7nh \u2018<strong>Sort Descending<\/strong>\u2018 .<\/li>\n<\/ol>\n<p style=\"text-align: justify\">L\u01b0u \u00fd r\u1eb1ng b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 s\u1eafp x\u1ebfp b\u1ea3ng theo th\u1ee9 t\u1ef1 b\u1ea3ng ch\u1eef c\u00e1i, d\u1ef1a theo t\u00ean c\u1ee7a ng\u01b0\u1eddi b\u00e1n h\u00e0ng (Barnes v\u00e0 Smith), b\u1eb1ng c\u00e1ch nh\u1ea5n v\u00e0o t\u00ean m\u1ed9t trong hai ng\u01b0\u1eddi v\u00e0 s\u1eafp x\u1ebfp theo th\u1ee9 t\u1ef1 t\u0103ng d\u1ea7n ho\u1eb7c gi\u1ea3m d\u1ea7n.<\/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\/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\/2025\/01\/vba101_92019-nho-33.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":11168,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-11167","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\/11167","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=11167"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/11167\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/11168"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=11167"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=11167"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=11167"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}