{"id":6489,"date":"2024-12-21T15:24:28","date_gmt":"2024-12-21T15:24:28","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/cach-de-dung-cung-mot-cach-loc-cho-nhieu-bang-pivot-table\/"},"modified":"2024-12-21T15:24:28","modified_gmt":"2024-12-21T15:24:28","slug":"cach-de-dung-cung-mot-cach-loc-cho-nhieu-bang-pivot-table","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/cach-de-dung-cung-mot-cach-loc-cho-nhieu-bang-pivot-table\/","title":{"rendered":"C\u00e1ch \u0111\u1ec3 d\u00f9ng c\u00f9ng m\u1ed9t c\u00e1ch l\u1ecdc cho nhi\u1ec1u b\u1ea3ng Pivot Table"},"content":{"rendered":"
\n

Th\u1ec9nh tho\u1ea3ng, b\u1ea1n mu\u1ed1n t\u1ea1o nhi\u1ec1u b\u1ea3ng Pivot Table d\u1ef1a v\u00e0o c\u00f9ng m\u1ed9t ngu\u1ed3n d\u1eef li\u1ec7u, b\u1ea1n l\u1ecdc m\u1ed9t b\u1ea3ng pivot v\u00e0 mu\u1ed1n nh\u1eefng b\u1ea3ng pivot kh\u00e1c c\u0169ng \u0111\u01b0\u1ee3c l\u1ecdc c\u00f9ng c\u00e1ch th\u1ee9c. H\u1ecdc Exceel Online mu\u1ed1n gi\u1edbi thi\u1ec7u t\u00ednh n\u0103ng Slicer trong Excel 2010 v\u00e0 2013.
\n1. T\u1ea1o c\u00e1c b\u1ea3ng Pivot d\u1ef1a tr\u00ean c\u00f9ng m\u1ed9t ngu\u1ed3n d\u1eef li\u1ec7u nh\u01b0 h\u00ecnh sau:<\/p>\n

<\/a>2. Nh\u1ea5p v\u00e0o b\u1ea5t k\u00ec \u00f4 n\u00e0o trong Pivot Table \u0111\u1ec3 m\u1edf PivotTable Tools<\/strong>, sau \u0111\u00f3 nh\u1ea5p Options<\/strong> > Insert Slicer<\/strong> > Insert Slicer<\/strong><\/p>\n

\"doc-filter-pivottables-1\"M\u1eb9o<\/strong>: Trong Excel 2013, h\u00e3y ch\u1ecdn Analyze<\/strong> > Insert Slicer<\/strong>.<\/p>\n

3. Trong h\u1ed9p tho\u1ea1i Insert Slicers<\/strong>, ch\u1ecdn nh\u1eefng tr\u01b0\u1eddng d\u1eef li\u1ec7u c\u1ea7n l\u1ecdc,\u00a0 sau \u0111\u00f3 nh\u1ea5p OK<\/p>\n

<\/a>4. Sau khi t\u1ea1o Slicer, h\u00e3y ch\u1ecdn ch\u00fang \u0111\u1ec3 hi\u1ec7n tab Slicer Tools<\/strong>, nh\u1ea5p Options<\/strong> > PivotTable Connections<\/strong><\/p>\n

\"doc-filter-pivottables-1\"<\/p>\n

5. Trong h\u1ed9p tho\u1ea1i PivotTable Connections<\/strong>, \u0111\u00e1nh d\u1ea5u pivot table m\u00e0 b\u1ea1n mu\u1ed1n l\u1ecdc c\u00f9ng l\u00fac<\/p>\n

\"doc-filter-pivottables-1\"<\/p>\n

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

6. Nh\u1ea5n OK \u0111\u1ec3 \u0111\u00f3ng n\u00f3 l\u1ea1i, khi b\u1ea1n nh\u1ea5p v\u00e0o m\u1ed9t m\u1ee5c c\u1ee7a danh s\u00e1ch Slicer, t\u1ea5t c\u1ea3 c\u00e1c m\u1ee5c li\u00ean quan s\u1ebd c\u00f9ng l\u00fac \u0111\u01b0\u1ee3c l\u1ecdc m\u1ed9t l\u1ea7n<\/p>\n

<\/a>Ch\u00fa \u00fd: Phi\u00ean b\u1ea3n 2007 kh\u00f4ng c\u00f3 t\u00ednh n\u0103ng n\u00e0y.<\/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":6490,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-6489","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\/6489","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=6489"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/6489\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/6490"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=6489"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=6489"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=6489"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}