Group Dates in Pivot Table

mrchonginhk

Well-known Member
Joined
Dec 3, 2004
Messages
679
I have a simple Pivot table just Dates plus Data.

I then right click the Date heading and tried to group dates.

However, it said "Cannot Group that Selection".
I have already removed all blank cell in Date field.

What can be wrong ??

Help !!!
 

Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.
Sometime I hate pivot tables!

Anyway - this is a little odd, but it worked for me - you need to refresh the pivot twice before the grouping kicks in again?!?

What I did:

1) Set up list with dates & gap in list
2) Set up pivot table
3) Tried to group on dates - got the error message
4) Filled in the missing date
5) Tried to group on dates - got the error message
6) Refreshed the data
7) Tried to group on dates - got the error message
8) Refreshed the data again
9) Tried to group on dates - grouping box pops up.

Tested a few times & seems to work...
 
Upvote 0
Thanks..

Just tried with no luck.

Anyone can tell what exactly is the prerequisite to do this Date Groupings (eg into weeks, month etc).

I used very simple dummy data and still did not work. ****...
 
Upvote 0
Minimum is having genuine date values in a contiguous range. What are your date values?
 
Upvote 0
highlight the column of 'dates', go to data | text to columns | hit next twice | select date & DMY from the drop down | hit finished
 
Upvote 0

Forum statistics

Threads
1,216,095
Messages
6,128,795
Members
449,468
Latest member
AGreen17

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top