Hello. I have a bunch of months/years as row values in a pivottable. It says can't group selection. Why is this? I made sure the formatting is date and it is.
Hello. I have a bunch of months/years as row values in a pivottable. It says can't group selection. Why is this? I made sure the formatting is date and it is.
Is it possible to upload a sample file?
Hi Amartino44,
I tried & was able to successfully group the date by Months, Quarters, Years.
Can you tell what steps are you following?
Regards,
AM
Hi Amartino44,
I tried & was able to successfully group the date by Months, Quarters, Years.
Can you tell what steps are you following?
Regards,
AM
If the column with the dates in your source data for the Pivot Table has text cells, the dates cannot be grouped. Here is a reference on the subject:
http://www.contextures.com/xlPivot07.html#Problems
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks