{"id":4576,"date":"2024-12-06T12:55:04","date_gmt":"2024-12-06T12:55:04","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/06\/tim-hieu-cach-bieu-dien-gia-tri-phan-tram-trong-bao-cao-bang-pivot-table\/"},"modified":"2024-12-06T12:55:04","modified_gmt":"2024-12-06T12:55:04","slug":"tim-hieu-cach-bieu-dien-gia-tri-phan-tram-trong-bao-cao-bang-pivot-table","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/06\/tim-hieu-cach-bieu-dien-gia-tri-phan-tram-trong-bao-cao-bang-pivot-table\/","title":{"rendered":"T\u00ecm hi\u1ec3u c\u00e1ch bi\u1ec3u di\u1ec5n gi\u00e1 tr\u1ecb ph\u1ea7n tr\u0103m trong b\u00e1o c\u00e1o b\u1eb1ng Pivot Table"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Pivot Table l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 r\u1ea5t h\u1eefu \u00edch trong vi\u1ec7c l\u1eadp b\u00e1o c\u00e1o. M\u1ed9t trong nh\u1eefng \u01b0u \u0111i\u1ec3m d\u1ec5 nh\u1eadn th\u1ea5y l\u00e0 b\u00e1o c\u00e1o b\u1eb1ng Pivot Table kh\u00f4ng h\u1ec1 d\u00f9ng t\u1edbi c\u00f4ng th\u1ee9c,\u00a0nh\u01b0ng n\u00f3 l\u1ea1i th\u1ec3 hi\u1ec7n \u0111\u01b0\u1ee3c r\u1ea5t nhi\u1ec1u d\u1ea1ng k\u1ebft qu\u1ea3 kh\u00e1c nhau. M\u1ed9t trong s\u1ed1 \u0111\u00f3 l\u00e0 bi\u1ec3u di\u1ec5n d\u1eef li\u1ec7u theo gi\u00e1 tr\u1ecb ph\u1ea7n tr\u0103m (%). H\u00e3y c\u00f9ng t\u00ecm hi\u1ec3u c\u00e1ch l\u00e0m n\u00e0y \u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n nh\u01b0 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<p><label for=\"ez-toc-cssicon-toggle-item-6752f4276254a\" 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\/tim-hieu-cach-bieu-dien-gia-tri-phan-tram-trong-bao-cao-bang-pivot-table.html#Cach_tao_bao_cao_bang_Pivot_Table\" title=\"C\u00e1ch t\u1ea1o b\u00e1o c\u00e1o b\u1eb1ng Pivot Table\">C\u00e1ch t\u1ea1o b\u00e1o c\u00e1o b\u1eb1ng Pivot Table<\/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\/tim-hieu-cach-bieu-dien-gia-tri-phan-tram-trong-bao-cao-bang-pivot-table.html#Cach_bieu_dien_gia_tri_phan_tram_trong_bao_cao_bang_Pivot_Table\" title=\"C\u00e1ch bi\u1ec3u di\u1ec5n gi\u00e1 tr\u1ecb ph\u1ea7n tr\u0103m trong b\u00e1o c\u00e1o b\u1eb1ng Pivot Table\">C\u00e1ch bi\u1ec3u di\u1ec5n gi\u00e1 tr\u1ecb ph\u1ea7n tr\u0103m trong b\u00e1o c\u00e1o b\u1eb1ng Pivot Table<\/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\/tim-hieu-cach-bieu-dien-gia-tri-phan-tram-trong-bao-cao-bang-pivot-table.html#Y_nghia_cua_nhung_gia_tri_trong_Show_Values_As_cua_Pivot_Table\" title=\"\u00dd ngh\u0129a c\u1ee7a nh\u1eefng gi\u00e1 tr\u1ecb % trong Show Values As c\u1ee7a Pivot Table\">\u00dd ngh\u0129a c\u1ee7a nh\u1eefng gi\u00e1 tr\u1ecb % trong Show Values As c\u1ee7a Pivot Table<\/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-4\" href=\"https:\/\/blog.hocexcel.online\/tim-hieu-cach-bieu-dien-gia-tri-phan-tram-trong-bao-cao-bang-pivot-table.html#_of_Grand_Total\" title=\"% of Grand Total\">% of Grand Total<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/tim-hieu-cach-bieu-dien-gia-tri-phan-tram-trong-bao-cao-bang-pivot-table.html#_of_Column_Total\" title=\"% of Column Total\">% of Column Total<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/tim-hieu-cach-bieu-dien-gia-tri-phan-tram-trong-bao-cao-bang-pivot-table.html#_of_Row_Total\" title=\"% of Row Total\">% of Row Total<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/blog.hocexcel.online\/tim-hieu-cach-bieu-dien-gia-tri-phan-tram-trong-bao-cao-bang-pivot-table.html#_of_Parent_Column\" title=\"% of Parent Column\">% of Parent Column<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/blog.hocexcel.online\/tim-hieu-cach-bieu-dien-gia-tri-phan-tram-trong-bao-cao-bang-pivot-table.html#_of_Parent_Row\" title=\"% of Parent Row\">% of Parent Row<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/blog.hocexcel.online\/tim-hieu-cach-bieu-dien-gia-tri-phan-tram-trong-bao-cao-bang-pivot-table.html#_of_Difference\" title=\"% of Difference\">% of Difference<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/blog.hocexcel.online\/tim-hieu-cach-bieu-dien-gia-tri-phan-tram-trong-bao-cao-bang-pivot-table.html#_of_Running_Total\" title=\"% of Running Total\">% of Running Total<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Cach_tao_bao_cao_bang_Pivot_Table\"><\/span>C\u00e1ch t\u1ea1o b\u00e1o c\u00e1o b\u1eb1ng Pivot Table<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Tr\u01b0\u1edbc h\u1ebft ch\u00fang ta c\u1ea7n nh\u1eafc l\u1ea1i 1 ch\u00fat v\u1ec1 vi\u1ec7c t\u1ea1o b\u00e1o c\u00e1o Pivot Table. Gi\u1ea3 s\u1eed ch\u00fang ta c\u00f3 b\u1ea3ng d\u1eef li\u1ec7u nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-22351\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/pivottable-show-value-as-data-1.png\" width=\"800\" height=\"287\" title=\"pivottable-show-value-as-data-1\"><\/p>\n<p>B\u1ea3ng d\u1eef li\u1ec7u g\u1ed3m 7 c\u1ed9t v\u00e0 102 d\u00f2ng, trong \u0111\u00f3 ti\u00eau \u0111\u1ec1 c\u1ee7a m\u1ed7i c\u1ed9t \u1edf d\u00f2ng 2.<\/p>\n<p>C\u00e1c b\u1ea1n c\u00f3 th\u1ec3 t\u1ea3i v\u1ec1 file m\u1eabu c\u1ee7a b\u00e0i vi\u1ebft n\u00e0y t\u1ea1i \u0111\u1ecba ch\u1ec9:\u00a0<a href=\"http:\/\/bit.ly\/2NyeKYK\">http:\/\/bit.ly\/2NyeKYK<\/a><\/p>\n<p>T\u1eeb b\u1ea3ng d\u1eef li\u1ec7u n\u00e0y, ch\u00fang ta c\u00f3 y\u00eau c\u1ea7u <strong>l\u1eadp b\u00e1o c\u00e1o v\u1ec1 chi ph\u00ed QC cho m\u1ed7i nh\u00e2n vi\u00ean trong c\u00e1c nh\u00f3m.<\/strong><\/p>\n<p>Theo y\u00eau c\u1ea7u tr\u00ean, ch\u00fang ta c\u00f3 th\u1ec3 x\u00e1c \u0111\u1ecbnh c\u00e1c th\u00e0nh ph\u1ea7n c\u1ea5u tr\u00fac c\u1ee7a b\u00e1o c\u00e1o 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-369.gif\" title=\"ex101_92019-nho-369\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<ul>\n<li>K\u1ebft qu\u1ea3 c\u1ea7n t\u00ednh\u00a0trong c\u1ed9t\u00a0<strong>chi ph\u00ed QC<\/strong><\/li>\n<li>\u0110\u1ed1i t\u01b0\u1ee3ng b\u00e1o c\u00e1o g\u1ed3m c\u00e1c c\u1ed9t<strong> Nh\u00f3m<\/strong> v\u00e0 <strong>Nh\u00e2n vi\u00ean<\/strong>, trong \u0111\u00f3 Nh\u00e2n vi\u00ean \u0111\u01b0\u1ee3c t\u1eadp h\u1ee3p trong c\u00e1c Nh\u00f3m.<\/li>\n<\/ul>\n<p>Sau khi \u0111\u00e3 x\u00e1c \u0111\u1ecbnh r\u00f5 c\u00e1c th\u00e0nh ph\u1ea7n c\u1ea5u tr\u00fac c\u1ee7a b\u00e1o c\u00e1o, ch\u00fang ta ti\u1ebfn h\u00e0nh l\u1eadp b\u00e1o c\u00e1o b\u1eb1ng Pivot Table nh\u01b0 sau:<\/p>\n<ul>\n<li>Ch\u1ecdn b\u1ea3ng d\u1eef li\u1ec7u<\/li>\n<li>Ch\u1ecdn th\u1ebb Insert\/ Pivot Table<\/li>\n<li>Trong c\u1eeda s\u1ed5 Create Pivot Table, m\u1ee5c <strong>Choose where you want the PivotTable report to be placed<\/strong>\u00a0\u0111\u00e1nh d\u1ea5u ch\u1ecdn t\u1ea1i <strong>Existing Worksheet<\/strong> \u0111\u1ec3 \u0111\u1eb7t b\u00e1o c\u00e1o v\u00e0o Sheet \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh, trong \u0111\u00f3 <strong>Location<\/strong> s\u1ebd ch\u1ecdn t\u1edbi <strong>Sheet BaoCao<\/strong>, \u00f4 <strong>A1<\/strong><\/li>\n<li>Trong PivotTable Fieds ch\u00fang ta t\u1ed5 ch\u1ee9c c\u00e1c tr\u01b0\u1eddng d\u1eef li\u1ec7u nh\u01b0 sau:<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-22352\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/pivottable-show-value-as-create-pivot.png\" width=\"600\" height=\"541\" title=\"pivottable-show-value-as-create-pivot\"><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cach_bieu_dien_gia_tri_phan_tram_trong_bao_cao_bang_Pivot_Table\"><\/span>C\u00e1ch bi\u1ec3u di\u1ec5n gi\u00e1 tr\u1ecb ph\u1ea7n tr\u0103m trong b\u00e1o c\u00e1o b\u1eb1ng Pivot Table<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Nh\u01b0 \u0111\u00e3 tr\u00ecnh b\u00e0y \u1edf \u0111\u1ea7u b\u00e0i vi\u1ebft, m\u1ee5c \u0111\u00edch c\u1ee7a ch\u00fang ta trong b\u00e0i vi\u1ebft n\u00e0y l\u00e0 t\u00ecm hi\u1ec3u v\u1ec1 c\u00e1ch bi\u1ec3u di\u1ec5n\u00a0gi\u00e1 tr\u1ecb ph\u1ea7n tr\u0103m trong b\u00e1o c\u00e1o Pivot Table. V\u1eady l\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 c\u00f3 th\u1ec3 chuy\u1ec3n d\u1eef li\u1ec7u t\u1eeb d\u1ea1ng S\u1ed1 sang d\u1ea1ng % m\u00e0 kh\u00f4ng d\u00f9ng t\u1edbi c\u00f4ng th\u1ee9c? V\u00e0 trong Pivot Table c\u00f3 nh\u1eefng c\u00e1ch bi\u1ec3u di\u1ec5n % nh\u01b0 th\u1ebf n\u00e0o?<\/p>\n<p>Tr\u01b0\u1edbc h\u1ebft \u0111\u1ec3 c\u00f3 th\u1ec3 b\u00e1o c\u00e1o v\u1eeba d\u1eef li\u1ec7u d\u1ea1ng S\u1ed1, v\u1eeba d\u1eef li\u1ec7u d\u1ea1ng % cho c\u00f9ng 1 n\u1ed9i dung, ch\u00fang ta s\u1ebd th\u00eam tr\u01b0\u1eddng d\u1eef li\u1ec7u \u0111\u00e3 c\u00f3\u00a0trong m\u1ee5c Values v\u00e0o \u0111\u00e2y 1 l\u1ea7n n\u1eefa, hay n\u00f3i c\u00e1ch kh\u00e1c l\u00e0 tr\u01b0\u1eddng d\u1eef li\u1ec7u t\u1ea1i Values \u0111\u01b0\u1ee3c l\u1eb7p l\u1ea1i nhi\u1ec1u l\u1ea7n.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-22353\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/pivottable-show-value-as-double-values-fields.png\" width=\"600\" height=\"451\" title=\"pivottable-show-value-as-double-values-fields\"><\/p>\n<p>Khi \u0111\u00f3 ch\u00fang ta th\u1ea5y c\u00f3 t\u1edbi 2 c\u1ed9t <strong>Sum of Chi ph\u00ed QC<\/strong><\/p>\n<p>T\u1ea1i c\u1ed9t\u00a0<strong>Sum of Chi ph\u00ed QC2<\/strong>, ch\u00fang ta s\u1ebd chuy\u1ec3n gi\u00e1 tr\u1ecb t\u1ea1i c\u1ed9t n\u00e0y v\u1ec1 d\u1ea1ng % nh\u01b0 sau:<\/p>\n<ul>\n<li>B\u1ea5m chu\u1ed9t ph\u1ea3i v\u00e0o v\u1ecb tr\u00ed b\u1ea5t k\u1ef3 trong c\u1ed9t\u00a0\u00a0<strong>Sum of Chi ph\u00ed QC2<\/strong>, ch\u1ecdn <strong>Show Values As<\/strong><\/li>\n<li>Trong m\u1ee5c <strong>Show Values As<\/strong> ch\u1ecdn <strong>% of Parent Row Total<\/strong><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-22354\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/pivottable-show-value-as-show-value-as-parent-row-total.png\" width=\"600\" height=\"489\" title=\"pivottable-show-value-as-show-value-as-parent-row-total\"><\/p>\n<p>Nh\u01b0 v\u1eady ch\u00fang ta \u0111\u00e3 c\u00f3 \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 d\u01b0\u1edbi d\u1ea1ng %, trong \u0111\u00f3:<\/p>\n<ul>\n<li>T\u1ed5ng c\u00e1c nh\u00f3m A, B, C b\u1eb1ng 100% = Grand Total<\/li>\n<li>T\u1ed5ng chi ti\u1ebft c\u00e1c nh\u00e2n vi\u00ean trong m\u1ed7i nh\u00f3m = 100% = Subtotal<\/li>\n<\/ul>\n<p>Vi\u1ec7c c\u00f2n l\u1ea1i \u0111\u1ec3 ho\u00e0n thi\u1ec7n b\u00e1o c\u00e1o ch\u1ec9 l\u00e0 \u0111\u1ed5i t\u00ean c\u00e1c tr\u01b0\u1eddng d\u1eef li\u1ec7u, tr\u00ecnh b\u00e0y \u0111\u1ecbnh d\u1ea1ng b\u00e1o c\u00e1o sao cho \u0111\u1eb9p.<\/p>\n<p>Xem th\u00eam:<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-lap-bao-cao-tien-do-thuc-hien-cong-viec-bang-pivot-table-tren-excel.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch l\u1eadp b\u00e1o c\u00e1o % ti\u1ebfn \u0111\u1ed9 th\u1ef1c hi\u1ec7n c\u00f4ng vi\u1ec7c b\u1eb1ng PivotTable tr\u00ean Excel<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-lap-bao-cao-theo-nhieu-dieu-kien-bang-pivot-table.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch l\u1eadp b\u00e1o c\u00e1o theo nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n b\u1eb1ng Pivot Table<\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Y_nghia_cua_nhung_gia_tri_trong_Show_Values_As_cua_Pivot_Table\"><\/span>\u00dd ngh\u0129a c\u1ee7a nh\u1eefng gi\u00e1 tr\u1ecb % trong Show Values As c\u1ee7a Pivot Table<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Ch\u00fang ta c\u00f3 th\u1ec3 th\u1ea5y c\u00f3 r\u1ea5t nhi\u1ec1u n\u1ed9i dung b\u00ean trong ph\u1ea7n Show Values As. C\u1ee5 th\u1ec3 \u00fd ngh\u0129a c\u1ee7a t\u1eebng n\u1ed9i dung n\u00e0y nh\u01b0 sau:<\/p>\n<h3><span class=\"ez-toc-section\" id=\"_of_Grand_Total\"><\/span>% of Grand Total<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>M\u1ed7i n\u1ed9i dung s\u1ebd t\u00ednh % tr\u00ean t\u1ed5ng c\u1ee7a to\u00e0n b\u1ed9 c\u00e1c n\u1ed9i dung. N\u1ebfu d\u1eef li\u1ec7u c\u00f3 nhi\u1ec1u c\u1ed9t ho\u1eb7c nhi\u1ec1u d\u00f2ng (t\u01b0\u01a1ng \u1ee9ng theo tr\u01b0\u1eddng \u0111\u1eb7t t\u1ea1i Columns ho\u1eb7c Rows) th\u00ec s\u1ebd t\u00ednh tr\u00ean t\u1ed5ng to\u00e0n b\u1ed9 c\u00e1c c\u1ed9t, c\u00e1c d\u00f2ng.<\/p>\n<p>G\u1ecdi m\u1ed7i n\u1ed9i dung l\u00e0 A, t\u1ed5ng to\u00e0n b\u1ed9 c\u00e1c n\u1ed9i dung l\u00e0 SUM_A ch\u00fang ta c\u00f3:<\/p>\n<p style=\"padding-left: 30px\"><strong>% of Grand Total = (A\/Sum_A)*100%<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-22356\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/pivot-table-with-show-values-as-percent-of-grand-total.png\" width=\"368\" height=\"302\" title=\"pivot-table-with-show-values-as-percent-of-grand-total\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"_of_Column_Total\"><\/span>% of Column Total<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Column Total l\u00e0 t\u1ed5ng theo t\u1eebng c\u1ed9t. T\u1ed5ng c\u00e1c n\u1ed9i dung trong c\u1ed9t l\u00e0 100%. C\u00e1ch t\u00ednh n\u00e0y gi\u1ed1ng v\u1edbi % of Grand Total nh\u01b0ng \u00e1p d\u1ee5ng cho 1 c\u1ed9t c\u1ee5 th\u1ec3, kh\u00f4ng ph\u1ea3i to\u00e0n tr\u00ean b\u1ed9 k\u1ebft qu\u1ea3.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-22355\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/pivot-table-with-show-values-as-percent-of-column-total.png\" width=\"353\" height=\"302\" title=\"pivot-table-with-show-values-as-percent-of-column-total\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"_of_Row_Total\"><\/span>% of Row Total<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Row Total l\u00e0 t\u1ed5ng theo t\u1eebng d\u00f2ng.\u00a0T\u1ed5ng c\u00e1c n\u1ed9i dung tr\u00ean 1 d\u00f2ng\u00a0l\u00e0 100%. T\u01b0\u01a1ng t\u1ef1 nh\u01b0 c\u00e1ch t\u00ednh % of Column Total nh\u01b0ng t\u00ednh theo d\u00f2ng<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-22357\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/pivot-table-with-show-values-as-percent-of-row-total.png\" width=\"355\" height=\"306\" title=\"pivot-table-with-show-values-as-percent-of-row-total\"><\/p>\n<p>Tham kh\u1ea3o:\u00a0<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<h3><span class=\"ez-toc-section\" id=\"_of_Parent_Column\"><\/span>% of Parent Column<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u00c1p d\u1ee5ng khi tr\u00ean khu v\u1ef1c Columns c\u00f3 nhi\u1ec1u h\u01a1n 1 tr\u01b0\u1eddng d\u1eef li\u1ec7u, tr\u01b0\u1eddng n\u1eb1m \u1edf tr\u00ean trong khu v\u1ef1c Columns l\u00e0 Parent<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-22358\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/parent-column-in-a-pivot-table.png\" width=\"261\" height=\"283\" title=\"parent-column-in-a-pivot-table\"><\/p>\n<p>M\u1ed7i \u0111\u1ed1i t\u01b0\u1ee3ng chi ti\u1ebft c\u1ee7a nh\u00f3m s\u1ebd t\u00ednh theo t\u1ed5ng % c\u1ee7a nh\u00f3m \u0111\u00f3 ch\u1ee9 kh\u00f4ng ph\u1ea3i theo to\u00e0n b\u1ed9 t\u1ea5t c\u1ea3 nh\u01b0 <strong>Grand Total<\/strong> hay <strong>Column Total<\/strong><\/p>\n<h3><span class=\"ez-toc-section\" id=\"_of_Parent_Row\"><\/span>% of Parent Row<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u00c1p d\u1ee5ng khi tr\u00ean khu v\u1ef1c Rows c\u00f3 nhi\u1ec1u h\u01a1n 1 tr\u01b0\u1eddng d\u1eef li\u1ec7u, tr\u01b0\u1eddng n\u1eb1m \u1edf tr\u00ean trong khu v\u1ef1c Rows l\u00e0 Parent<\/p>\n<p>\u00a0<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-22359\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/parent-row-in-a-pivot-table.png\" width=\"253\" height=\"281\" title=\"parent-row-in-a-pivot-table\"><\/p>\n<p>M\u1ed7i \u0111\u1ed1i t\u01b0\u1ee3ng chi ti\u1ebft c\u1ee7a nh\u00f3m s\u1ebd t\u00ednh theo t\u1ed5ng % c\u1ee7a nh\u00f3m \u0111\u00f3 ch\u1ee9 kh\u00f4ng ph\u1ea3i theo to\u00e0n b\u1ed9 t\u1ea5t c\u1ea3 nh\u01b0\u00a0<strong>Grand Total<\/strong>\u00a0hay\u00a0Row<strong>\u00a0Total<\/strong><\/p>\n<h3><span class=\"ez-toc-section\" id=\"_of_Difference\"><\/span>% of Difference<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Ch\u00eanh l\u1ec7ch t\u00ednh theo % gi\u1eefa 2 gi\u00e1 tr\u1ecb li\u1ec1n nhau \u1edf 2 d\u00f2ng (hay n\u00f3i c\u00e1ch kh\u00e1c l\u00e0 t\u00ednh ch\u00eanh l\u1ec7ch theo % gi\u1eefa d\u00f2ng tr\u00ean v\u1edbi d\u00f2ng d\u01b0\u1edbi).<\/p>\n<p>Vi\u1ec7c t\u00ednh ch\u00eanh l\u1ec7ch \u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n li\u00ean t\u1ee5c tr\u00ean c\u00e1c d\u00f2ng (c\u00f3 x\u00e9t t\u00ednh li\u00ean t\u1ee5c)<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-22360\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/pivot-table-with-show-values-as-percent-difference-from.png\" width=\"581\" height=\"212\" title=\"pivot-table-with-show-values-as-percent-difference-from\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"_of_Running_Total\"><\/span>% of Running Total<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>T\u00ednh % theo d\u1ea1ng t\u0103ng d\u1ea7n theo d\u00f2ng. M\u1ed7i khi th\u00eam 1 d\u00f2ng m\u1edbi th\u00ec t\u1ef7 l\u1ec7 % s\u1ebd t\u0103ng l\u00ean. C\u00e1ch t\u00ednh:<\/p>\n<p>G\u1ecdi T\u1ed5ng c\u1ea3 c\u1ed9t l\u00e0 Sum_A<\/p>\n<p>M\u1ed7i gi\u00e1 tr\u1ecb trong c\u1ed9t l\u00e0 A1, A2, A3\u2026<\/p>\n<p style=\"padding-left: 30px\">% of Running Total t\u1ea1i A1 = ((A1)\/Sum_A)*100%<\/p>\n<p style=\"padding-left: 30px\">% of Running Total t\u1ea1i A2 = ((A1+A2)\/Sum_A)*100%<\/p>\n<p style=\"padding-left: 30px\">% of Running Total t\u1ea1i A3 = ((A1+A2+A3)\/Sum_A)*100%<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-22361\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/pivot-table-with-show-values-as-percent-running-total-in.png\" width=\"521\" height=\"212\" title=\"pivot-table-with-show-values-as-percent-running-total-in\"><\/p>\n<p>Ngu\u1ed3n tham kh\u1ea3o:\u00a0<em>https:\/\/www.howtoexcel.org<\/em><\/p>\n<p>Nh\u01b0 v\u1eady qua b\u00e0i vi\u1ebft n\u00e0y ch\u00fang ta \u0111\u00e3 bi\u1ebft th\u00eam \u0111\u01b0\u1ee3c kh\u00e1 nhi\u1ec1u c\u00e1ch th\u1ec3 hi\u1ec7n gi\u00e1 tr\u1ecb % trong b\u00e1o c\u00e1o b\u1eb1ng Pivot Table r\u1ed3i ph\u1ea3i kh\u00f4ng n\u00e0o.<\/p>\n<p>\u0110\u1ec3 c\u00f3 th\u1ec3 l\u00e0m t\u1ed1t b\u00e1o c\u00e1o tr\u00ean Excel, b\u1ea1n c\u1ea7n ph\u1ea3i n\u1eafm v\u1eefng k\u1ef9 thu\u1eadt t\u1ea1o Pivot Table, k\u1ef9 thu\u1eadt t\u00f9y bi\u1ebfn d\u1eef li\u1ec7u trong Pivot Table \u0111\u1ec3 ph\u00f9 h\u1ee3p v\u1edbi m\u1ee5c ti\u00eau b\u00e1o c\u00e1o. Ngo\u00e0i ra m\u1ed9t n\u1ed9i dung r\u1ea5t quan tr\u1ecdng n\u1eefa l\u00e0 c\u00e1ch t\u1ed5 ch\u1ee9c, qu\u1ea3n l\u00fd d\u1eef li\u1ec7u trong\u00a0b\u1ea3ng d\u1eef li\u1ec7u nh\u01b0 th\u1ebf n\u00e0o \u0111\u1ec3 gi\u00fap c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng \u0111\u01b0\u1ee3c Pivot Table. B\u1edfi kh\u00f4ng ph\u1ea3i l\u00fac n\u00e0o ch\u00fang ta c\u0169ng c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng ngay Pivot Table cho b\u1ea3ng d\u1eef li\u1ec7u, v\u00ec c\u00f3 th\u1ec3 d\u1eef li\u1ec7u ch\u01b0a ch\u00ednh x\u00e1c v\u1ec1 lo\u1ea1i d\u1eef li\u1ec7u s\u1ebd d\u1eabn t\u1edbi k\u1ebft qu\u1ea3 c\u1ee7a b\u00e1o c\u00e1o Pivot Table b\u1ecb sai.<\/p>\n<p>B\u1ea1n mu\u1ed1n t\u0103ng t\u01b0 duy v\u1ec1 t\u1ed5 ch\u1ee9c d\u1eef li\u1ec7u, c\u1ea3i thi\u1ec7n k\u1ef9 n\u0103ng l\u1eadp b\u00e1o c\u00e1o tr\u00ean Excel? H\u00e3y \u0111\u1ecdc th\u00eam b\u00e0i vi\u1ebft n\u00e0y:<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/tai-sao-ban-can-hoc-ky-nang-chuc-du-lieu-va-lap-bao-cao-tren-excel.html\">T\u1ea1i sao b\u1ea1n c\u1ea7n h\u1ecdc k\u1ef9 n\u0103ng t\u1ed5 ch\u1ee9c d\u1eef li\u1ec7u v\u00e0 l\u1eadp b\u00e1o c\u00e1o tr\u00ean Excel<\/a><\/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-369.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":4577,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-4576","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\/4576","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=4576"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/4576\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/4577"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=4576"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=4576"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=4576"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}