{"id":6498,"date":"2024-12-21T15:26:14","date_gmt":"2024-12-21T15:26:14","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/huong-dan-cach-hien-thi-cac-doi-tuong-bi-gop-nhom-trong-pivot-table-excel\/"},"modified":"2024-12-21T15:26:14","modified_gmt":"2024-12-21T15:26:14","slug":"huong-dan-cach-hien-thi-cac-doi-tuong-bi-gop-nhom-trong-pivot-table-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/huong-dan-cach-hien-thi-cac-doi-tuong-bi-gop-nhom-trong-pivot-table-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch hi\u1ec3n th\u1ecb c\u00e1c \u0111\u1ed1i t\u01b0\u1ee3ng b\u1ecb g\u1ed9p nh\u00f3m trong Pivot table Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Khi l\u00e0m b\u00e1o c\u00e1o b\u1eb1ng Pivot Table tr\u00ean Excel, ch\u00fang ta hay g\u1eb7p ph\u1ea3i 1 v\u1ea5n \u0111\u1ec1 l\u00e0 c\u00e1ch Pivot table t\u1ef1 \u0111\u1ed9ng t\u1ea1o ki\u1ec3u b\u00e1o c\u00e1o. Nh\u01b0ng ki\u1ec3u b\u00e1o c\u00e1o \u0111\u00f3 \u0111\u00f4i khi kh\u00f4ng \u0111\u00fang nh\u01b0 mong mu\u1ed1n c\u1ee7a ch\u00fang ta. L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 t\u00f9y bi\u1ebfn l\u1ea1i b\u00e1o c\u00e1o b\u1eb1ng Pivot table? H\u00e3y c\u00f9ng H\u1ecdc Excel Online t\u00ecm hi\u1ec3u\u00a0c\u00e1ch hi\u1ec3n th\u1ecb c\u00e1c \u0111\u1ed1i t\u01b0\u1ee3ng b\u1ecb g\u1ed9p nh\u00f3m trong Pivot table Excel.<\/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-6766de154ab0a\" 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\/huong-dan-cach-hien-thi-cac-doi-tuong-bi-gop-nhom-trong-pivot-table-excel.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\/huong-dan-cach-hien-thi-cac-doi-tuong-bi-gop-nhom-trong-pivot-table-excel.html#Thay_doi_phuong_thuc_gop_nhom_trong_Pivot_table\" title=\"Thay \u0111\u1ed5i ph\u01b0\u01a1ng th\u1ee9c g\u1ed9p nh\u00f3m trong Pivot table\">Thay \u0111\u1ed5i ph\u01b0\u01a1ng th\u1ee9c g\u1ed9p nh\u00f3m trong Pivot table<\/a><\/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\u00f9ng t\u00ecm hi\u1ec3u l\u1ea1i c\u00e1ch t\u1ea1o b\u00e1o c\u00e1o b\u1eb1ng Pivot table tr\u00ean Excel th\u00f4ng qua v\u00ed d\u1ee5 sau:<\/p>\n<p>Cho b\u1ea3ng d\u1eef li\u1ec7u nh\u01b0 h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y. B\u1ea3ng d\u1eef li\u1ec7u n\u00e0y c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 t\u1ea3i v\u1ec1 t\u1ea1i \u0111\u1ecba ch\u1ec9:<\/p>\n<p>Y\u00eau c\u1ea7u l\u1eadp b\u00e1o c\u00e1o theo t\u1eebng m\u00e3 hi\u1ec7u c\u1ee7a kh\u00e1ch h\u00e0ng Doanh nghi\u1ec7p, trong ch\u01b0\u01a1ng tr\u00ecnh ti\u1ebft ki\u1ec7m c\u1ee7a chi nh\u00e1nh 2<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-20237\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/data-pivot-table-ngan-hang-1.png\" width=\"812\" height=\"326\" title=\"data-pivot-table-ngan-hang-1\"><\/p>\n<p>C\u00e1c y\u00eau c\u1ea7u b\u00e1o c\u00e1o nghe c\u00f3 v\u1ebb ph\u1ee9c t\u1ea1p ph\u1ea3i kh\u00f4ng n\u00e0o. H\u00e3y xem c\u00e1ch th\u1ec3 hi\u1ec7n b\u00e1o c\u00e1o n\u00e0y tr\u00ean Pivot table nh\u00e9:<\/p>\n<p><strong>B\u01b0\u1edbc 1:<\/strong> ch\u1ecdn to\u00e0n b\u1ed9 b\u1ea3ng d\u1eef li\u1ec7u b\u1eb1ng c\u00e1ch ch\u1ecdn 1 v\u1ecb tr\u00ed b\u1ea5t k\u1ef3 trong b\u1ea3ng d\u1eef li\u1ec7u r\u1ed3i b\u1ea5m ph\u00edm t\u1eaft Ctrl + * (ph\u00edm ctrl v\u00e0 ph\u00edm d\u1ea5u *)<\/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-582.gif\" title=\"ex101_92019-nho-582\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><strong>B\u01b0\u1edbc 2:<\/strong> trong th\u1ebb Insert ch\u1ecdn Pivot Table. Ch\u1ecdn n\u01a1i \u0111\u1eb7t Pivot table l\u00e0 1 sheet m\u1edbi<\/p>\n<p><strong>B\u01b0\u1edbc 3:<\/strong> x\u00e1c \u0111\u1ecbnh c\u00e1c th\u00e0nh ph\u1ea7n trong b\u00e1o c\u00e1o b\u1eb1ng Pivot table<\/p>\n<p>\u0110\u1ec3 th\u1ef1c hi\u1ec7n b\u01b0\u1edbc n\u00e0y, ch\u00fang ta ph\u1ea3i c\u0103n c\u1ee9 v\u00e0o c\u00e1c y\u00eau c\u1ea7u c\u1ee7a b\u00e1o c\u00e1o:<\/p>\n<ul>\n<li>T\u1eebng m\u00e3 hi\u1ec7u c\u1ee7a kh\u00e1ch h\u00e0ng l\u00e0 kh\u00e1ch l\u1ebb =&gt; Trong <strong>Rows<\/strong> \u0111\u1eb7t 2 tr\u01b0\u1eddng <strong>M\u00e3 hi\u1ec7u v\u00e0 Kh\u00e1ch h\u00e0ng<\/strong><\/li>\n<li>Ch\u01b0\u01a1ng tr\u00ecnh l\u00e0 Ti\u1ebft ki\u1ec7m =&gt; Trong <strong>Columns<\/strong> \u0111\u1eb7t tr\u01b0\u1eddng <strong>Ch\u01b0\u01a1ng tr\u00ecnh<\/strong><\/li>\n<li>Chi nh\u00e1nh 2 =&gt; Trong <strong>Filters<\/strong> \u0111\u1eb7t tr\u01b0\u1eddng <strong>Chi nh\u00e1nh<\/strong><\/li>\n<li>K\u1ebft qu\u1ea3 b\u00e1o c\u00e1o l\u00e0 s\u1ed1 ti\u1ec1n =&gt; Trong <strong>Values<\/strong> \u0111\u1eb7t tr\u01b0\u1eddng <strong>S\u1ed1 ti\u1ec1n<\/strong>.<\/li>\n<\/ul>\n<p>K\u1ebft qu\u1ea3 b\u00e1o c\u00e1o nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-20380\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/tao-bang-pivot-table-theo-3-dk.png\" width=\"933\" height=\"648\" title=\"tao-bang-pivot-table-theo-3-dk\"><\/p>\n<p>Sau khi t\u1ea1o ra Pivot Table, ch\u00fang ta th\u1ef1c hi\u1ec7n l\u1ecdc c\u00e1c \u0111\u1ed1i t\u01b0\u1ee3ng c\u1ee7a b\u00e1o c\u00e1o \u0111\u1ec3 ph\u00f9 h\u1ee3p v\u1edbi y\u00eau c\u1ea7u b\u00e1o c\u00e1o:<\/p>\n<ul>\n<li>Chi nh\u00e1nh: Ch\u1ecdn chi nh\u00e1nh 2<\/li>\n<li>Kh\u00e1ch h\u00e0ng: Ch\u1ecdn Doanh nghi\u1ec7p<\/li>\n<li>Ch\u01b0\u01a1ng tr\u00ecnh: Ch\u1ecdn Ti\u1ebft ki\u1ec7m<\/li>\n<\/ul>\n<p>K\u1ebft qu\u1ea3 nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-20381\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/loc-ket-qua-bao-cao-pivot-table.png\" width=\"508\" height=\"426\" title=\"loc-ket-qua-bao-cao-pivot-table\"><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Thay_doi_phuong_thuc_gop_nhom_trong_Pivot_table\"><\/span>Thay \u0111\u1ed5i ph\u01b0\u01a1ng th\u1ee9c g\u1ed9p nh\u00f3m trong Pivot table<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Kh\u00f4ng ph\u1ea3i l\u00fac n\u00e0o vi\u1ec7c tr\u00ecnh b\u00e0y b\u00e1o c\u00e1o t\u1ef1 \u0111\u1ed9ng b\u1eb1ng Pivot table c\u0169ng ph\u00f9 h\u1ee3p v\u1edbi nhu c\u1ea7u b\u00e1o c\u00e1o c\u1ee7a ch\u00fang ta.\u00a0V\u00ed d\u1ee5 nh\u01b0 tr\u01b0\u1eddng h\u1ee3p n\u00e0y ch\u00fang ta mu\u1ed1n thay \u0111\u1ed5i ph\u01b0\u01a1ng th\u1ee9c g\u1ed9p nh\u00f3m c\u00e1c \u0111\u1ed1i t\u01b0\u1ee3ng trong Pivot Table, m\u1ee5c Rows: chia th\u00e0nh 2 c\u1ed9t, 1 c\u1ed9t th\u1ec3 hi\u1ec7n \u0111\u1ed1i t\u01b0\u1ee3ng Kh\u00e1ch h\u00e0ng, 1 c\u1ed9t th\u1ec3 hi\u1ec7n chi ti\u1ebft M\u00e3 hi\u1ec7u c\u1ee7a t\u1eebng kh\u00e1ch h\u00e0ng.<\/p>\n<p>C\u00e1ch th\u1ef1c hi\u1ec7n nh\u01b0 sau:<\/p>\n<p><strong>B\u01b0\u1edbc 1<\/strong>: Chuy\u1ec3n Pivot table v\u1ec1 d\u1ea1ng Classic (d\u1ea1ng c\u01a1 b\u1ea3n, d\u1ea1ng c\u1ed5 \u0111i\u1ec3n)<\/p>\n<p>B\u1ea5m chu\u1ed9t ph\u1ea3i v\u00e0o b\u1ea3ng Pivot table v\u00e0 ch\u1ecdn <strong>PivotTable Options<\/strong>. Trong c\u1eeda s\u1ed5 PivotTable Options, ch\u1ecdn th\u1ebb <strong>Display<\/strong>, trong n\u00e0y ch\u1ecdn <strong>Classic PivotTable layout<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-20383\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/pivot-table-display-classic.png\" width=\"564\" height=\"644\" title=\"pivot-table-display-classic\"><\/p>\n<p>Khi chuy\u1ec3n PivotTable v\u1ec1 d\u1ea1ng Classic, ch\u00fang ta \u0111\u01b0\u1ee3c m\u1eabu b\u00e1o c\u00e1o nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-20384\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/pivot-table-classic-form.png\" width=\"560\" height=\"426\" title=\"pivot-table-classic-form\"><\/p>\n<p><strong>B\u01b0\u1edbc 2<\/strong>: Hi\u1ec3n th\u1ecb h\u1ebft c\u00e1c \u0111\u1ed1i t\u01b0\u1ee3ng \u0111\u01b0\u1ee3c g\u1ed9p nh\u00f3m. C\u1ee5 th\u1ec3 \u1edf \u0111\u00e2y l\u00e0 c\u1ed9t Kh\u00e1ch h\u00e0ng s\u1ebd hi\u1ec3n th\u1ecb m\u1ed7i d\u00f2ng 1 gi\u00e1 tr\u1ecb, thay cho vi\u1ec7c g\u1ed9p th\u00e0nh 1 nh\u00f3m.<\/p>\n<p>Trong th\u1ebb <strong>PivotTable Tools<\/strong>, m\u1ee5c <strong>Design<\/strong> ch\u1ecdn <strong>Report Layout<\/strong>. Trong m\u1ee5c Report Layout ch\u1ecdn <strong>Repeat all item labels<\/strong>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-20385\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/pivot-table-display-report-layout.png\" width=\"1105\" height=\"439\" title=\"pivot-table-display-report-layout\"><\/p>\n<p>Nh\u01b0 v\u1eady sau khi ho\u00e0n t\u1ea5t c\u00e1c thao t\u00e1c th\u00ec ch\u00fang ta ra k\u1ebft qu\u1ea3 l\u00e0 b\u1ea3n b\u00e1o c\u00e1o b\u1eb1ng Pivot Table nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-20386\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ket-qua-pivot-table-classic-repeat-all-item-labels.png\" width=\"528\" height=\"404\" title=\"ket-qua-pivot-table-classic-repeat-all-item-labels\"><\/p>\n<p>R\u1ea5t \u0111\u01a1n gi\u1ea3n v\u00e0 hi\u1ec7u qu\u1ea3 ph\u1ea3i kh\u00f4ng n\u00e0o. Hy v\u1ecdng qua b\u00e0i vi\u1ebft n\u00e0y c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 n\u00e2ng cao \u0111\u01b0\u1ee3c kh\u1ea3 n\u0103ng l\u1eadp b\u00e1o c\u00e1o b\u1eb1ng c\u00f4ng c\u1ee5 PivotTable. C\u00f4ng c\u1ee5 PivotTable l\u00e0 1 c\u00f4ng c\u1ee5 r\u1ea5t h\u1eefu \u00edch trong Excel gi\u00fap ch\u00fang ta c\u00f3 th\u1ec3 l\u1eadp nh\u1eefng b\u00e1o c\u00e1o ph\u1ee9c t\u1ea1p m\u1ed9t c\u00e1ch d\u1ec5 d\u00e0ng, nhanh ch\u00f3ng.<\/p>\n<p>Xem th\u00eam:<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/cach-lap-bao-cao-theo-thang-bang-pivot-table-khi-du-lieu-khong-co-san-cot-thang.html\">C\u00e1ch l\u1eadp b\u00e1o c\u00e1o theo th\u00e1ng b\u1eb1ng pivot table khi d\u1eef li\u1ec7u kh\u00f4ng c\u00f3 s\u1eb5n c\u1ed9t th\u00e1ng<\/a><\/p>\n<p style=\"padding-left: 30px\"><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<p>Nh\u1eefng ki\u1ebfn th\u1ee9c n\u00e0y c\u00e1c b\u1ea1n ho\u00e0n to\u00e0n c\u00f3 th\u1ec3 h\u1ecdc \u0111\u01b0\u1ee3c th\u00f4ng qua kh\u00f3a h\u1ecdc <a href=\"http:\/\/bit.ly\/2uvRXkq\">EX101 \u2013 Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi chuy\u00ean gia c\u1ee7a H\u1ecdc Excel Online<\/a>. Kh\u00f4ng ch\u1ec9 ri\u00eang c\u00f4ng c\u1ee5 PivotTable m\u00e0 c\u00f2n nhi\u1ec1u c\u00f4ng c\u1ee5, nhi\u1ec1u h\u00e0m kh\u00e1c trong Excel gi\u00fap b\u1ea1n \u1ee9ng d\u1ee5ng t\u1ed1t v\u00e0o c\u00f4ng vi\u1ec7c. H\u00e3y tham gia ngay \u0111\u1ec3 nh\u1eadn \u0111\u01b0\u1ee3c nhi\u1ec1u \u01b0u \u0111\u00e3i. 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-582.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":6499,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-6498","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\/6498","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=6498"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/6498\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/6499"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=6498"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=6498"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=6498"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}