How to group dates in a pivot tables with extra (non-date) columnsChanging date ranges in pivot tableAdd a new column into Pivot Table using VBAExcel Pivot Table issue setting a column to “Running Total” using VBAInserting data in a pivot table via a macroDelphi Controlling Excel - Creating Pivot Tables and ChartsUsing defined name with Dates for pivot table does not workExcel pivot table “Distinct Count” not compatible with Group for dates?Pivot Table: is it possible to group by date and also show the date for particular entriesReplace Empty Pivot Table Cells with Previous Value in ExcelVBA - How do I group columns in a pivot table, collapse the group, and rename the label?
Alternatives to minimizing loss in regression
How can Paypal know my card is being used in another account?
Can I attune a Circlet of Human Perfection to my animated skeletons to allow them to blend in and speak?
What is the reason for cards stating "Until end of turn, you don't lose this mana as steps and phases end"?
Summoning A Technology Based Demon
GNU GPL V3 with no code change disclosure
Complexity of verifying optimality in (mixed) integer programming
Why did House of Representatives need to condemn Trumps Tweets?
Why did some Apollo missions carry a grenade launcher?
If the Moon were impacted by a suitably sized meteor, how long would it take to impact the Earth?
Why is it "on the inside" and not "in the inside"?
To find islands of 1 and 0 in matrix
Exploiting the delay when a festival ticket is scanned
What is the German equivalent of the proverb 水清ければ魚棲まず (if the water is clear, fish won't live there)?
GNU sort stable sort when sort does not know sort order
Did Vladimir Lenin have a cat?
How to efficiently shred a lot of cabbage?
Should I intervene when a colleague in a different department makes students run laps as part of their grade?
How did the SysRq key get onto modern keyboards if it's rarely used?
Convert graph format for Mathematica graph functions
A variant of the Multiple Traveling Salesman Problem
Why does the Eurostar not show youth pricing?
Why did Windows 95 crash the whole system but newer Windows only crashed programs?
Rampant sharing of authorship among colleagues in the name of "collaboration". Is not taking part in it a death knell for a future in academia?
How to group dates in a pivot tables with extra (non-date) columns
Changing date ranges in pivot tableAdd a new column into Pivot Table using VBAExcel Pivot Table issue setting a column to “Running Total” using VBAInserting data in a pivot table via a macroDelphi Controlling Excel - Creating Pivot Tables and ChartsUsing defined name with Dates for pivot table does not workExcel pivot table “Distinct Count” not compatible with Group for dates?Pivot Table: is it possible to group by date and also show the date for particular entriesReplace Empty Pivot Table Cells with Previous Value in ExcelVBA - How do I group columns in a pivot table, collapse the group, and rename the label?
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;
I have some data with "Completion Dates". These dates range from 1/1/19 to middle of 2020. But some of the dates are not set yet and the data says "Missing". I am trying to automate a pivot table using a macro. I need the dates to be a column based in quarters. It also needs a column for 2020 and a column for MISSING. So it will read:
|Missing|--|Q1 2019|--|Q2 2019|--|Q3 2019|--|Q4 2019|--|2020|
The missing can be wither at the front or back (but prefer the front).
I cannot hard code the cell locations since the dates can change, be added, or deleted at anytime. I know how to group by date, but the MISSING is breaking everything I've tried.
This needs to be completely done in VBA. I don't want any manual input.
excel vba grouping pivot-table
edited Mar 27 at 7:54
Pᴇʜ
30.4k6 gold badges30 silver badges56 bronze badges
asked Mar 26 at 20:25
tdlanghetdlanghe
163 bronze badges
add a comment |
I have some data with "Completion Dates". These dates range from 1/1/19 to middle of 2020. But some of the dates are not set yet and the data says "Missing". I am trying to automate a pivot table using a macro. I need the dates to be a column based in quarters. It also needs a column for 2020 and a column for MISSING. So it will read:
|Missing|--|Q1 2019|--|Q2 2019|--|Q3 2019|--|Q4 2019|--|2020|
The missing can be wither at the front or back (but prefer the front).
I cannot hard code the cell locations since the dates can change, be added, or deleted at anytime. I know how to group by date, but the MISSING is breaking everything I've tried.
This needs to be completely done in VBA. I don't want any manual input.
excel vba grouping pivot-table
edited Mar 27 at 7:54
Pᴇʜ
30.4k6 gold badges30 silver badges56 bronze badges
asked Mar 26 at 20:25
tdlanghetdlanghe
163 bronze badges
1
Can you make a helper column that will group the dates accordingly?
– dwirony
Mar 26 at 20:32
@dwirony I really wanted to go around that but seemed to be the only thing that worked. Appreciate the help.
– tdlanghe
Mar 27 at 14:30
add a comment |
I have some data with "Completion Dates". These dates range from 1/1/19 to middle of 2020. But some of the dates are not set yet and the data says "Missing". I am trying to automate a pivot table using a macro. I need the dates to be a column based in quarters. It also needs a column for 2020 and a column for MISSING. So it will read:
|Missing|--|Q1 2019|--|Q2 2019|--|Q3 2019|--|Q4 2019|--|2020|
The missing can be wither at the front or back (but prefer the front).
I cannot hard code the cell locations since the dates can change, be added, or deleted at anytime. I know how to group by date, but the MISSING is breaking everything I've tried.
This needs to be completely done in VBA. I don't want any manual input.
excel vba grouping pivot-table
edited Mar 27 at 7:54
Pᴇʜ
30.4k6 gold badges30 silver badges56 bronze badges
asked Mar 26 at 20:25
tdlanghetdlanghe
163 bronze badges
I have some data with "Completion Dates". These dates range from 1/1/19 to middle of 2020. But some of the dates are not set yet and the data says "Missing". I am trying to automate a pivot table using a macro. I need the dates to be a column based in quarters. It also needs a column for 2020 and a column for MISSING. So it will read:
|Missing|--|Q1 2019|--|Q2 2019|--|Q3 2019|--|Q4 2019|--|2020|
The missing can be wither at the front or back (but prefer the front).
I cannot hard code the cell locations since the dates can change, be added, or deleted at anytime. I know how to group by date, but the MISSING is breaking everything I've tried.
This needs to be completely done in VBA. I don't want any manual input.
excel vba grouping pivot-table
excel vba grouping pivot-table
edited Mar 27 at 7:54
Pᴇʜ
30.4k6 gold badges30 silver badges56 bronze badges
asked Mar 26 at 20:25
tdlanghetdlanghe
163 bronze badges
edited Mar 27 at 7:54
Pᴇʜ
30.4k6 gold badges30 silver badges56 bronze badges
asked Mar 26 at 20:25
tdlanghetdlanghe
163 bronze badges
edited Mar 27 at 7:54
Pᴇʜ
30.4k6 gold badges30 silver badges56 bronze badges
edited Mar 27 at 7:54
Pᴇʜ
30.4k6 gold badges30 silver badges56 bronze badges
edited Mar 27 at 7:54
Pᴇʜ
30.4k6 gold badges30 silver badges56 bronze badges
30.4k6 gold badges30 silver badges56 bronze badges
asked Mar 26 at 20:25
tdlanghetdlanghe
163 bronze badges
asked Mar 26 at 20:25
tdlanghetdlanghe
163 bronze badges
asked Mar 26 at 20:25
tdlanghetdlanghe
163 bronze badges
163 bronze badges
1
Can you make a helper column that will group the dates accordingly?
– dwirony
Mar 26 at 20:32
@dwirony I really wanted to go around that but seemed to be the only thing that worked. Appreciate the help.
– tdlanghe
Mar 27 at 14:30
add a comment |
1
Can you make a helper column that will group the dates accordingly?
– dwirony
Mar 26 at 20:32
@dwirony I really wanted to go around that but seemed to be the only thing that worked. Appreciate the help.
– tdlanghe
Mar 27 at 14:30
1
1
Can you make a helper column that will group the dates accordingly?
– dwirony
Mar 26 at 20:32
Can you make a helper column that will group the dates accordingly?
– dwirony
Mar 26 at 20:32
@dwirony I really wanted to go around that but seemed to be the only thing that worked. Appreciate the help.
– tdlanghe
Mar 27 at 14:30
@dwirony I really wanted to go around that but seemed to be the only thing that worked. Appreciate the help.
– tdlanghe
Mar 27 at 14:30
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
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
);
);
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%2fstackoverflow.com%2fquestions%2f55365677%2fhow-to-group-dates-in-a-pivot-tables-with-extra-non-date-columns%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
Is this question similar to what you get asked at work? Learn more about asking and sharing private information with your coworkers using Stack Overflow for Teams.
Is this question similar to what you get asked at work? Learn more about asking and sharing private information with your coworkers using Stack Overflow for Teams.
Thanks for contributing an answer to Stack Overflow!
- 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.
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%2fstackoverflow.com%2fquestions%2f55365677%2fhow-to-group-dates-in-a-pivot-tables-with-extra-non-date-columns%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
1
Can you make a helper column that will group the dates accordingly?
– dwirony
Mar 26 at 20:32
@dwirony I really wanted to go around that but seemed to be the only thing that worked. Appreciate the help.
– tdlanghe
Mar 27 at 14:30