{"id":6932,"date":"2024-12-21T16:32:49","date_gmt":"2024-12-21T16:32:49","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/cach-nhom-theo-tuan-trong-pivot-table\/"},"modified":"2024-12-21T16:32:49","modified_gmt":"2024-12-21T16:32:49","slug":"cach-nhom-theo-tuan-trong-pivot-table","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/cach-nhom-theo-tuan-trong-pivot-table\/","title":{"rendered":"C\u00e1ch nh\u00f3m theo tu\u1ea7n trong Pivot Table"},"content":{"rendered":"
\n

Khi nh\u00f3m trong Pivot Table, b\u1ea1n c\u00f3 th\u1ec3 nh\u00f3m theo th\u00e1ng, ng\u00e0y, qu\u00fd, n\u0103m. Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, H\u1ecdc Excel Online s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n nh\u00f3m theo tu\u1ea7n.<\/p>\n

Nh\u00f3m theo tu\u1ea7n trong Pivot Table ( 7 ng\u00e0y )<\/strong><\/p>\n

1. Sau khi \u0111\u00e3 t\u1ea1o b\u1ea3ng Pivot, nh\u1ea5n chu\u1ed9t ph\u1ea3i v\u00e0o b\u1ea5t k\u00ec ng\u00e0y n\u00e0o trong b\u1ea3ng, ch\u1ecdn Group<\/strong><\/p>\n

\"doc-group-by-week-pivot-table-1\"<\/p>\n

2. Trong h\u1ed9p tho\u1ea1i Grouping, h\u00e3y l\u00e0m nh\u01b0 sau:<\/p>\n

A: <\/strong>D\u01b0\u1edbi ph\u1ea7n Auto<\/strong>, nh\u1eadp ng\u00e0y b\u1eaft \u0111\u1ea7u c\u1ee7a 1 tu\u1ea7n. Trong v\u00ed d\u1ee5 n\u00e0y, ng\u00e0y \u0111\u1ea7u ti\u00ean l\u00e0 12\/3\/2014, nh\u01b0ng n\u00f3 kh\u00f4ng ph\u1ea3i ng\u00e0y \u0111\u1ea7u ti\u00ean c\u1ee7a tu\u1ea7n, b\u1edfi v\u1eady n\u00f3 \u0111\u01b0\u1ee3c \u0111\u1ed5i th\u00e0nh 10\/3\/2014 l\u00e0 ng\u00e0y \u0111\u1ea7u ti\u00ean c\u1ee7a tu\u1ea7n b\u1eaft \u0111\u1ea7u t\u1eeb th\u1ee9 2. Kh\u00f4ng c\u1ea7n x\u00e1c \u0111\u1ecbnh ng\u00e0y k\u1ebft th\u00fac tu\u1ea7n.<\/p>\n

B<\/strong>: Ch\u1ecdn Days<\/strong> t\u1eeb danh s\u00e1ch By<\/strong><\/p>\n

C<\/strong>: Nh\u1eadp 7 v\u00e0o h\u1ed9p Number of days<\/strong><\/p>\n

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

\"doc-group-by-week-pivot-table-1\"<\/p>\n

3. Nh\u1ea5n OK.<\/p>\n

\"doc-group-by-week-pivot-table-1\"<\/p>\n

Nh\u00f3m theo tu\u1ea7n trong pivot Table b\u1eb1ng c\u1ed9t ph\u1ee5<\/strong>
\nTrong Excel, b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 th\u00eam c\u1ed9t ph\u1ee5 \u0111\u1ec3 t\u00ednh s\u1ed1 tu\u1ea7n d\u1ef1a v\u00e0o ng\u00e0y th\u00e1ng, v\u00e0 sau \u0111\u00f3 ch\u1ecdn d\u1ea3i d\u1eef li\u1ec7u bao g\u1ed3m tr\u01b0\u1eddng n\u00e0y \u0111\u1ec3 t\u1ea1o b\u1ea3ng pivot. H\u00e3y l\u00e0m theo c\u00e1c b\u01b0\u1edbc sau:<\/p>\n

1. Tr\u01b0\u1edbc ti\u00ean, h\u00e3y t\u00ednh c\u00e1c s\u1ed1 tu\u1ea7n d\u1ef1a v\u00e0o ng\u00e0y, nh\u1eadp c\u00f4ng th\u1ee9c n\u00e0y: = YEAR (D2) & \u201c-\u201d & TEXT (WEEKNUM (D2,2), \u201c00\u201d)<\/strong> v\u00e0o m\u1ed9t \u00f4 tr\u1ed1ng b\u00ean c\u1ea1nh d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n, (D2 ch\u1ec9 ra \u00d4 ng\u00e0y m\u00e0 b\u1ea1n mu\u1ed1n s\u1eed d\u1ee5ng):<\/p>\n

\"doc-group-by-week-pivot-table-1\"<\/p>\n

2. Sau \u0111\u00f3 k\u00e9o c\u00f4ng th\u1ee9c \u0111\u1ebfn t\u1ea5t c\u1ea3 c\u00e1c d\u00f2ng c\u1ea7n nh\u00f3m.<\/p>\n

\"doc-group-by-week-pivot-table-1\"<\/p>\n

3. Ch\u1ecdn to\u00e0n b\u1ed9 b\u1ea3ng bao g\u1ed3m c\u1ea3 c\u1ed9t ph\u1ee5 ph\u00eda tr\u00ean, ch\u1ecdn Insert<\/strong> > PivotTable<\/strong> > PivotTable<\/strong><\/p>\n

\"doc-group-by-week-pivot-table-1\"<\/p>\n

4. Trong h\u1ed9p tho\u1ea1i , ch\u1ecdn trang t\u00ednh m\u1edbi ho\u1eb7c v\u00f9ng s\u1ebd \u0111\u1eb7t Pivot Table d\u01b0\u1edbi ph\u1ea7n Choose where you want the PivotTable report to be placed<\/strong><\/p>\n

\"doc-group-by-week-pivot-table-1\"<\/p>\n

5. Nh\u1ea5n OK. K\u00e9o nh\u1eefng tr\u01b0\u1eddng v\u00e0o danh s\u00e1ch li\u00ean quan, \u0111\u1eb7t Week <\/strong>\u1edf \u0111\u1ea7u ph\u1ea7n Row Labels<\/strong><\/p>\n

<\/a><\/p>\n

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