{"id":11495,"date":"2025-01-15T03:40:53","date_gmt":"2025-01-15T03:40:53","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/cach-an-hang-chua-gia-tri-0-trong-pivot-table\/"},"modified":"2025-01-15T03:40:53","modified_gmt":"2025-01-15T03:40:53","slug":"cach-an-hang-chua-gia-tri-0-trong-pivot-table","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/cach-an-hang-chua-gia-tri-0-trong-pivot-table\/","title":{"rendered":"C\u00e1ch \u1ea9n h\u00e0ng ch\u1ee9a gi\u00e1 tr\u1ecb 0 trong Pivot Table"},"content":{"rendered":"
\n

\u1ea8n c\u00e1c h\u00e0ng c\u00f3 ch\u1ee9a gi\u00e1 tr\u1ecb b\u1eb1ng kh\u00f4ng trong Pivot Table l\u00e0 \u0111i\u1ec1u ph\u1ed5 bi\u1ebfn. Trong b\u00e0i vi\u1ebft n\u00e0y, H\u1ecdc Excel Online s\u1ebd h\u01b0\u1edbng d\u1eabn v\u00e0i c\u00e1ch \u0111\u1ec3 \u1ea9n h\u00e0ng c\u00f3 ch\u1ee9a gi\u00e1 tr\u1ecb 0 trong Pivot Table.<\/p>\n

\u1ea8n h\u00e0ng ch\u1ee9a gi\u00e1 tr\u1ecb 0 b\u1eb1ng c\u00e1ch t\u1ea1o v\u00f9ng l\u1ecdc<\/strong><\/p>\n

\u0110\u1ec3 \u1ea9n h\u00e0ng c\u00f3 gi\u00e1 tr\u1ecb 0 trong pivot table, vui l\u00f2ng l\u00e0m theo c\u00e1c b\u01b0\u1edbc sau:<\/p>\n

1. Sau khi t\u1ea1o pivot table, trong c\u1eeda s\u1ed5 PivotTable Field List, <\/strong>k\u00e9o nh\u1eefng ph\u1ea7n b\u1ea1n mu\u1ed1n \u1ea9n gi\u00e1 tr\u1ecb 0 t\u1eeb h\u1ed9p Choose fields to add to report <\/strong>t\u1edbi h\u1ed9p Report Filter<\/strong>, v\u00e0 nh\u1eefng ph\u1ea7n \u0111\u00f3 s\u1ebd \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb ph\u1ea7n \u0111\u1ea7u b\u1ea3ng nh\u01b0 h\u00ecnh:<\/p>\n

<\/p>\n

2. B\u1ea5m v\u00e0o d\u1ea5u m\u0169i t\u00ean xu\u1ed1ng c\u1ee7a ph\u1ea7n b\u1ea1n mu\u1ed1n \u1ea9n gi\u00e1 tr\u1ecb 0, b\u1ea5m ch\u1ecdn Select Multiple Items<\/strong>,b\u1ecf ch\u1ecdn 0, nh\u01b0 h\u00ecnh:<\/p>\n

\"doc-hide-zeros-pivot-table-1\"<\/p>\n

3. B\u1ea5m OK, v\u00e0 t\u1ea5t c\u1ea3 c\u00e1c h\u00e0ng c\u00f3 s\u1ed1 0 \u0111\u00e3 \u0111\u01b0\u1ee3c \u1ea9n. N\u1ebfu c\u1ea7n \u1ea9n c\u00e1c gi\u00e1 tr\u1ecb 0 c\u1ee7a ph\u1ea7n kh\u00e1c, h\u00e3y l\u1eb7p l\u1ea1i b\u01b0\u1edbc 2.<\/p>\n

\n
\n
\n
\n<\/a>\n<\/div>\n<\/div>\n
\n
\n
\n
\n<\/a>\n<\/div>\n<\/div>\n

\"doc-hide-zeros-pivot-table-1\"<\/p>\n

\u1ea8n h\u00e0ng ch\u1ee9a gi\u00e1 tr\u1ecb 0 b\u1eb1ng ch\u1ee9c n\u0103ng l\u1ecdc trong PivotTable<\/strong><\/p>\n

B\u00ean c\u1ea1nh ph\u01b0\u01a1ng ph\u00e1p tr\u00ean, b5n c\u0169ng c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng t\u00ednh n\u0103ng Filter trong pivot table \u0111\u1ec3 \u1ea9n h\u00e0ng c\u00f3 gi\u00e1 tr\u1ecb 0. H\u00e3y l\u00e0m nh\u01b0 sau:<\/p>\n

1. Trong pivot table, ch\u1ecdn b\u1ea5t c\u1ee9 d\u00f2ng n\u00e0o c\u00f3 n\u1ed9i dung, nh\u1ea5p ph\u1ea3i, ch\u1ecdn Filter<\/strong> > Value Filters<\/strong><\/p>\n

\"doc-hide-zeros-pivot-table-1\"<\/p>\n

2. Trong h\u1ed9p tho\u1ea1i Value Filter<\/strong>, ch\u1ecdn ph\u1ea7n d\u1eef li\u1ec7u b\u1ea1n mu\u1ed1n \u1ea9n gi\u00e1 tr\u1ecb 0 t\u1eeb danh s\u00e1ch t\u00f9y ch\u1ecdn, ch\u1ecdn does not equal<\/strong> t\u1eeb danh s\u00e1ch t\u00f9y ch\u1ecdn th\u1ee9 2, cu\u1ed1i c\u00f9ng nh\u1eadp 0<\/p>\n

\"doc-hide-zeros-pivot-table-1\"<\/p>\n

3. Nh\u1ea5n OK v\u00e0 \u0111\u00f3ng h\u1ed9p tho\u1ea1i.<\/p>\n

\"doc-hide-zeros-pivot-table-1\"<\/p>\n

Ch\u00fa \u00fd: V\u1edbi ph\u01b0\u01a1ng ph\u00e1p n\u00e0y, b\u1ea1n ch\u1ec9 c\u00f3 th\u1ec3 \u1ea9n gi\u00e1 tr\u1ecb 0 c\u1ee7a m\u1ed9t lo\u1ea1i d\u1eef li\u1ec7u, n\u1ebfu b\u1ea1n mu\u1ed1n ch\u1ecdn lo\u1ea1i kh\u00e1c, th\u00ec gi\u00e1 tr\u1ecb \u1ea9n tr\u01b0\u1edbc \u0111\u00f3 s\u1ebd hi\u1ec3n th\u1ecb l\u1ea1i.<\/p>\n<\/div>\n

\n

Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n

T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0\ud83d\udcd6<\/span><\/a><\/p>\n

H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n

HKD H\u1ecdc Excel Online
S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n

\n

\u00a9 document.currentScript.insertAdjacentHTML(‘afterend’, ” + new Intl.DateTimeFormat(document.documentElement.lang, {year: ‘numeric’}).format() + ”); H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

\n
\n
\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":11496,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-11495","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\/11495","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=11495"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/11495\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/11496"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=11495"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=11495"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=11495"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}