{"id":4712,"date":"2024-12-08T07:17:44","date_gmt":"2024-12-08T07:17:44","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/08\/cach-lap-bao-cao-ty-le-phan-tram-trong-excel-bang-pivot-table-don-gian-nhat\/"},"modified":"2024-12-08T07:17:44","modified_gmt":"2024-12-08T07:17:44","slug":"cach-lap-bao-cao-ty-le-phan-tram-trong-excel-bang-pivot-table-don-gian-nhat","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/08\/cach-lap-bao-cao-ty-le-phan-tram-trong-excel-bang-pivot-table-don-gian-nhat\/","title":{"rendered":"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"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>T\u1eeb m\u1ed9t b\u1ea3ng d\u1eef li\u1ec7u ban \u0111\u1ea7u, \u0111\u1ec3 c\u00f3 th\u1ec3\u00a0l\u1eadp b\u00e1o c\u00e1o theo t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m\u00a0c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n theo 2 c\u00e1ch: M\u1ed9t l\u00e0 s\u1eed d\u1ee5ng h\u00e0m, c\u00f4ng th\u1ee9c \u0111\u1ec3 t\u00ednh, c\u00e1ch th\u1ee9 2 l\u00e0 s\u1eed d\u1ee5ng pivot table. Trong b\u00e0i vi\u1ebft n\u00e0y H\u1ecdc Excel Online s\u1ebd gi\u1edbi thi\u1ec7u v\u1edbi c\u00e1c b\u1ea1n c\u00e1ch\u00a0l\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<\/p>\n<p>Tham kh\u1ea3o b\u00e0i vi\u1ebft:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/ung-dung-ham-countifs-trong-bao-cao-theo-ty-le-va-ve-bieu-hinh-tron.html\">\u1ee8ng d\u1ee5ng h\u00e0m Countifs trong b\u00e1o c\u00e1o theo t\u1ef7 l\u1ec7 v\u00e0 v\u1ebd bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n<\/a><\/p>\n<p>Ch\u00fang ta s\u1ebd s\u1eed d\u1ee5ng lu\u00f4n file m\u1eabu v\u1ec1 b\u1ea3ng d\u1eef li\u1ec7u trong b\u00e0i vi\u1ebft tr\u00ean \u0111\u1ec3 \u00e1p d\u1ee5ng v\u1edbi c\u00e1ch l\u00e0m b\u1eb1ng Pivot Table<\/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-675548173915c\" 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-3\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/cach-lap-bao-cao-ty-le-phan-tram-trong-excel-bang-pivot-table-don-gian-nhat.html#1_Lap_bao_cao_bang_Pivot_Table_de_dem_ket_qua\" title=\"1. L\u1eadp b\u00e1o c\u00e1o b\u1eb1ng Pivot Table \u0111\u1ec3 \u0111\u1ebfm k\u1ebft qu\u1ea3\">1. L\u1eadp b\u00e1o c\u00e1o b\u1eb1ng Pivot Table \u0111\u1ec3 \u0111\u1ebfm k\u1ebft qu\u1ea3<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/cach-lap-bao-cao-ty-le-phan-tram-trong-excel-bang-pivot-table-don-gian-nhat.html#2_Thiet_lap_Pivot_Table_de_tinh_du_lieu_dang\" title=\"2. Thi\u1ebft l\u1eadp Pivot Table \u0111\u1ec3 t\u00ednh d\u1eef li\u1ec7u d\u1ea1ng %\">2. Thi\u1ebft l\u1eadp Pivot Table \u0111\u1ec3 t\u00ednh d\u1eef li\u1ec7u d\u1ea1ng %<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"1_Lap_bao_cao_bang_Pivot_Table_de_dem_ket_qua\"><\/span>1. L\u1eadp b\u00e1o c\u00e1o b\u1eb1ng Pivot Table \u0111\u1ec3 \u0111\u1ebfm k\u1ebft qu\u1ea3<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Kh\u00e1c v\u1edbi b\u00e1o c\u00e1o b\u1eb1ng h\u00e0m, c\u00f4ng th\u1ee9c khi ch\u00fang ta ph\u1ea3i v\u1ebd m\u1eabu b\u00e1o c\u00e1o tr\u01b0\u1edbc, r\u1ed3i sau \u0111\u00f3 vi\u1ebft h\u00e0m, c\u00f4ng th\u1ee9c v\u00e0o v\u1ecb tr\u00ed l\u1ea5y k\u1ebft qu\u1ea3 trong b\u00e1o c\u00e1o, th\u00ec vi\u1ec7c b\u00e1o c\u00e1o b\u1eb1ng <a href=\"http:\/\/blog.ezworkapp.com\/khoi-dau-voi-pivot-table-trong-excel.html\">Pivot Table<\/a> ch\u1ec9 vi\u1ec7c ch\u1ecdn b\u1ea3ng d\u1eef li\u1ec7u r\u1ed3i b\u1ea5m Insert\/Pivot Table.<\/p>\n<p>Trong c\u1eeda s\u1ed5 Create PivotTable ch\u00fa \u00fd v\u1ecb tr\u00ed \u0111\u1eb7t PivotTable. Ch\u00fang ta c\u00f3 th\u1ec3 \u0111\u1eb7t ngay t\u1ea1i Sheet ch\u1ee9a d\u1eef li\u1ec7u \u0111\u1ec3 ti\u1ec7n theo d\u00f5i:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-19244\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/insert-pivot-table-pie-chart.png\" width=\"847\" height=\"709\" title=\"insert-pivot-table-pie-chart\"><\/p>\n<p>Sau khi b\u1ea5m OK s\u1ebd\u00a0xu\u1ea5t hi\u1ec7n\u00a0giao di\u1ec7n t\u00f9y ch\u1ecdn c\u00e1c tr\u01b0\u1eddng d\u1eef li\u1ec7u \u0111\u1ec3 l\u1eadp b\u00e1o c\u00e1o. \u0110\u1ec3 c\u00f3 th\u1ec3 t\u1ea1o \u0111\u01b0\u1ee3c b\u00e1o c\u00e1o d\u1ea1ng \u0111\u1ebfm gi\u1ed1ng nh\u01b0 s\u1eed d\u1ee5ng h\u00e0m, c\u00f4ng th\u1ee9c th\u00ec ch\u00fang ta s\u1ebd thi\u1ebft l\u1eadp trong m\u1ee5c PivotTable Fields nh\u01b0 sau:<\/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\/2024\/12\/ex101_92019-nho-383.gif\" title=\"ex101_92019-nho-383\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<ul>\n<li>L\u1edbp: \u0111\u1eb7t v\u00e0o m\u1ee5c Rows<\/li>\n<li>X\u1ebfp lo\u1ea1i: \u0111\u1eb7t v\u00e0o m\u1ee5c Columns v\u00e0 m\u1ee5c Values. Trong m\u1ee5c Values ch\u1ecdn c\u00e1ch t\u00ednh l\u00e0 COUNT<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-19250\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/pivot-table-fields-setting.png\" width=\"815\" height=\"427\" title=\"pivot-table-fields-setting\"><\/p>\n<p>N\u1ebfu b\u1ea1n ch\u01b0a hi\u1ec3u r\u00f5 v\u1ec1 c\u00e1ch t\u1ea1o v\u00e0 thi\u1ebft l\u1eadp trong Pivot Table th\u00ec c\u00f3 th\u1ec3 xem th\u00eam t\u1ea1i b\u00e0i vi\u1ebft: Kh\u1edfi \u0111\u1ea7u v\u1edbi<a href=\"http:\/\/blog.ezworkapp.com\/khoi-dau-voi-pivot-table-trong-excel.html\">\u00a0Pivot table trong Excel<\/a><\/p>\n<p>Nh\u01b0 v\u1eady ch\u00fang ta c\u00f3 th\u1ec3 th\u1ea5y k\u1ebft qu\u1ea3 gi\u1ed1ng v\u1edbi d\u1ea1ng b\u00e1o c\u00e1o s\u1eed d\u1ee5ng h\u00e0m COUNTIFS r\u1ed3i ph\u1ea3i kh\u00f4ng n\u00e0o. C\u00e1c b\u1ea1n c\u00f3 th\u1ec3 c\u0103n ch\u1ec9nh \u0111\u1ed9 r\u1ed9ng c\u1ee7a c\u00e1c c\u1ed9t \u0111\u1ec3 tr\u00ecnh b\u00e0y b\u00e1o c\u00e1o cho \u0111\u1eb9p h\u01a1n.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"2_Thiet_lap_Pivot_Table_de_tinh_du_lieu_dang\"><\/span>2. Thi\u1ebft l\u1eadp Pivot Table \u0111\u1ec3 t\u00ednh d\u1eef li\u1ec7u d\u1ea1ng %<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Chuy\u1ec3n d\u1eef li\u1ec7u t\u1eeb d\u1ea1ng s\u1ed1 sang d\u1ea1ng % tr\u00ean t\u1ed5ng s\u1ed1 trong Pivot Table r\u1ea5t \u0111\u01a1n gi\u1ea3n. Ch\u00fang ta s\u1ebd th\u1ef1c hi\u1ec7n nh\u01b0 sau:<\/p>\n<ul>\n<li>X\u00e1c \u0111\u1ecbnh k\u1ebft qu\u1ea3 c\u1ea7n t\u00ednh. \u1ede \u0111\u00e2y l\u00e0 m\u1ee5c <strong>Count of X\u1ebfp lo\u1ea1i<\/strong>. B\u1ea5m chu\u1ed9t tr\u00e1i v\u00e0o m\u1ee5c n\u00e0y v\u00e0 ch\u1ecdn Value Field Settings\u2026<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-19255\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/pivot-table-value-fields-setting.png\" width=\"401\" height=\"330\" title=\"pivot-table-value-fields-setting\"><\/p>\n<ul>\n<li>Trong m\u1ee5c Value Field Settings ch\u1ecdn <strong>Summarize Values by = Count, Show Values As = % of Row Total<\/strong> nh\u01b0 h\u00ecnh b\u00ean d\u01b0\u1edbi:<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-19259\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/pivot-table-value-fields-setting-count-value.png\" width=\"1091\" height=\"415\" title=\"pivot-table-value-fields-setting-count-value\"><\/p>\n<p>K\u1ebft qu\u1ea3 thu \u0111\u01b0\u1ee3c s\u1ebd l\u00e0:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-19260\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/pivot-table-value-fields-setting-count-value-ketqua.png\" width=\"610\" height=\"140\" title=\"pivot-table-value-fields-setting-count-value-ketqua\"><\/p>\n<h3><\/h3>\n<p>\u0110\u00e2y ch\u00ednh l\u00e0 m\u1eabu b\u00e1o c\u00e1o t\u1ef7 l\u1ec7 % m\u00e0\u00a0ch\u00fang ta c\u1ea7n. K\u1ebft qu\u1ea3 gi\u1ed1ng v\u1edbi b\u00e1o c\u00e1o b\u1eb1ng h\u00e0m COUNTIFS k\u1ebft h\u1ee3p v\u1edbi ph\u00e9p t\u00ednh ra t\u1ef7 l\u1ec7 %, nh\u01b0ng v\u1edbi Pivot Table th\u00ec ch\u00fang ta kh\u00f4ng c\u1ea7n th\u1ef1c hi\u1ec7n ph\u00e9p t\u00ednh, ch\u1ec9 c\u1ea7n b\u1ea5m n\u00fat l\u1ef1a ch\u1ecdn theo \u0111\u00fang c\u00e1c n\u1ed9i dung c\u1ea7n tr\u00ecnh b\u00e0y tr\u00ean b\u00e1o c\u00e1o l\u00e0 \u0111\u01b0\u1ee3c.<\/p>\n<p>Tham kh\u1ea3o:<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/cach-loc-top-10-san-pham-ban-chay-nhat-trong-bao-cao-ban-hang-excel-bang-pivot-table.html\">C\u00e1ch l\u1ecdc top 10 s\u1ea3n ph\u1ea9m b\u00e1n ch\u1ea1y nh\u1ea5t trong b\u00e1o c\u00e1o b\u00e1n h\u00e0ng Excel b\u1eb1ng Pivot table<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/5-pivot-table-ma-chac-han-ban-chua-tung-gap-truoc-day.html\">5 Pivot Table m\u00e0 ch\u1eafc h\u1eb3n b\u1ea1n ch\u01b0a t\u1eebng g\u1eb7p tr\u01b0\u1edbc \u0111\u00e2y<\/a><\/p>\n<p>Ngo\u00e0i ra H\u1ecdc Excel Online xin gi\u1edbi thi\u1ec7u v\u1edbi c\u00e1c b\u1ea1n\u00a0<a href=\"http:\/\/bit.ly\/2KblIjI\"><strong>Kh\u00f3a h\u1ecdc\u00a0Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi n\u00e2ng cao d\u00e0nh cho ng\u01b0\u1eddi\u00a0\u0111i l\u00e0m<\/strong><\/a>.\u00a0\u0110\u00e2y l\u00e0 1 kh\u00f3a h\u1ecdc r\u1ea5t\u00a0\u0111\u1ea7y\u00a0\u0111\u1ee7 ki\u1ebfn th\u1ee9c v\u00e0 b\u1ed5 tr\u1ee3 r\u1ea5t tuy\u1ec7t v\u1eddi cho b\u1ea1n trong vi\u1ec7c l\u00e0m quen v\u1edbi Excel, s\u1eed d\u1ee5ng c\u00e1c c\u00f4ng c\u1ee5, c\u00e1c h\u00e0m trong\u00a0Excel\u00a0\u0111\u1ec3\u00a0gi\u00fap b\u1ea1n l\u00e0m vi\u1ec7c tr\u00ean\u00a0Excel\u00a0\u0111\u01b0\u1ee3c t\u1ed1t h\u01a1n, hi\u1ec7u qu\u1ea3 h\u01a1n. 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\/2024\/12\/ex101_92019-nho-383.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":4713,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-4712","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\/4712","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=4712"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/4712\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/4713"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=4712"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=4712"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=4712"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}