Excel Pivot - Group by year and week
0
I can group data by YEAR. I can also group it by WEEK. However, I can't seem to group it by YEAR and WEEK.
I used https://www.extendoffice.com/documents/excel/1874-excel-pivot-table-group-by-week.html for reference
Can this be done or is the fact a week can be between two years make it not feasible?
Thanks
microsoft-excel pivot-table powerpivot
asked Dec 21 '18 at 12:49
pee2pee
1215
add a comment |
0
I can group data by YEAR. I can also group it by WEEK. However, I can't seem to group it by YEAR and WEEK.
I used https://www.extendoffice.com/documents/excel/1874-excel-pivot-table-group-by-week.html for reference
Can this be done or is the fact a week can be between two years make it not feasible?
Thanks
microsoft-excel pivot-table powerpivot
asked Dec 21 '18 at 12:49
pee2pee
1215
you will need to share some sample data, and possibly a look of what you expect to be able to do, in order to get a meaningful answer. but in short Excel can do ANYTHING :)
– PeterH
Dec 21 '18 at 12:51
It's literally a list of dates that when I put into a pivot, I want to be able to group by Year and Week
– pee2pee
Dec 21 '18 at 13:49
Could you provide a sample about your PivotTable and data source for date Column?
– Lee
Dec 24 '18 at 7:51
A simple solution is to use some helper columns. In one, extract the year from each date. In the other, extract the week number from each date. Include both helper columns in the rows window of the pivot table. To go beyond generic advice, people will need more detail.
– fixer1234
Dec 29 '18 at 6:01
add a comment |
0
0
0
I can group data by YEAR. I can also group it by WEEK. However, I can't seem to group it by YEAR and WEEK.
I used https://www.extendoffice.com/documents/excel/1874-excel-pivot-table-group-by-week.html for reference
Can this be done or is the fact a week can be between two years make it not feasible?
Thanks
microsoft-excel pivot-table powerpivot
asked Dec 21 '18 at 12:49
pee2pee
1215
I can group data by YEAR. I can also group it by WEEK. However, I can't seem to group it by YEAR and WEEK.
I used https://www.extendoffice.com/documents/excel/1874-excel-pivot-table-group-by-week.html for reference
Can this be done or is the fact a week can be between two years make it not feasible?
Thanks
microsoft-excel pivot-table powerpivot
microsoft-excel pivot-table powerpivot
asked Dec 21 '18 at 12:49
pee2pee
1215
asked Dec 21 '18 at 12:49
pee2pee
1215
asked Dec 21 '18 at 12:49
pee2pee
1215
asked Dec 21 '18 at 12:49
pee2pee
1215
asked Dec 21 '18 at 12:49
pee2pee
1215
1215
you will need to share some sample data, and possibly a look of what you expect to be able to do, in order to get a meaningful answer. but in short Excel can do ANYTHING :)
– PeterH
Dec 21 '18 at 12:51
It's literally a list of dates that when I put into a pivot, I want to be able to group by Year and Week
– pee2pee
Dec 21 '18 at 13:49
Could you provide a sample about your PivotTable and data source for date Column?
– Lee
Dec 24 '18 at 7:51
A simple solution is to use some helper columns. In one, extract the year from each date. In the other, extract the week number from each date. Include both helper columns in the rows window of the pivot table. To go beyond generic advice, people will need more detail.
– fixer1234
Dec 29 '18 at 6:01
add a comment |
you will need to share some sample data, and possibly a look of what you expect to be able to do, in order to get a meaningful answer. but in short Excel can do ANYTHING :)
– PeterH
Dec 21 '18 at 12:51
It's literally a list of dates that when I put into a pivot, I want to be able to group by Year and Week
– pee2pee
Dec 21 '18 at 13:49
Could you provide a sample about your PivotTable and data source for date Column?
– Lee
Dec 24 '18 at 7:51
A simple solution is to use some helper columns. In one, extract the year from each date. In the other, extract the week number from each date. Include both helper columns in the rows window of the pivot table. To go beyond generic advice, people will need more detail.
– fixer1234
Dec 29 '18 at 6:01
you will need to share some sample data, and possibly a look of what you expect to be able to do, in order to get a meaningful answer. but in short Excel can do ANYTHING :)
– PeterH
Dec 21 '18 at 12:51
you will need to share some sample data, and possibly a look of what you expect to be able to do, in order to get a meaningful answer. but in short Excel can do ANYTHING :)
– PeterH
Dec 21 '18 at 12:51
It's literally a list of dates that when I put into a pivot, I want to be able to group by Year and Week
– pee2pee
Dec 21 '18 at 13:49
It's literally a list of dates that when I put into a pivot, I want to be able to group by Year and Week
– pee2pee
Dec 21 '18 at 13:49
Could you provide a sample about your PivotTable and data source for date Column?
– Lee
Dec 24 '18 at 7:51
Could you provide a sample about your PivotTable and data source for date Column?
– Lee
Dec 24 '18 at 7:51
A simple solution is to use some helper columns. In one, extract the year from each date. In the other, extract the week number from each date. Include both helper columns in the rows window of the pivot table. To go beyond generic advice, people will need more detail.
– fixer1234
Dec 29 '18 at 6:01
A simple solution is to use some helper columns. In one, extract the year from each date. In the other, extract the week number from each date. Include both helper columns in the rows window of the pivot table. To go beyond generic advice, people will need more detail.
– fixer1234
Dec 29 '18 at 6:01
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1386646%2fexcel-pivot-group-by-year-and-week%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
draft saved
draft discarded
Thanks for contributing an answer to Super User!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1386646%2fexcel-pivot-group-by-year-and-week%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
you will need to share some sample data, and possibly a look of what you expect to be able to do, in order to get a meaningful answer. but in short Excel can do ANYTHING :)
– PeterH
Dec 21 '18 at 12:51
It's literally a list of dates that when I put into a pivot, I want to be able to group by Year and Week
– pee2pee
Dec 21 '18 at 13:49
Could you provide a sample about your PivotTable and data source for date Column?
– Lee
Dec 24 '18 at 7:51
A simple solution is to use some helper columns. In one, extract the year from each date. In the other, extract the week number from each date. Include both helper columns in the rows window of the pivot table. To go beyond generic advice, people will need more detail.
– fixer1234
Dec 29 '18 at 6:01