|
|
#3
01-18-2022, 08:50 AM
|
||||
|
||||
It's because the the dates in the source data rows 269 and below are not real dates but strings which look like dates. In the attached I've converted them to real dates (using Text-to-Columns) and grouped the dates in the pivot table by years and months.
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Issue With Date In Pivot Table
|
tomohawk | Excel | 6 | 01-18-2022 08:42 AM |
| pivot table group by | HFLO | Excel | 0 | 06-08-2017 08:29 PM |
| Excel pivot table with a DATE value field for some reason stops at a certain date | angie450 | Excel Programming | 2 | 08-19-2014 08:50 AM |
|
Group Date by Quarter in PIVOT TABLE
|
shilabrow | Excel | 6 | 04-24-2014 10:44 AM |
| Group Table Rows/Column (like Excel Group) | eoinymc | Word | 1 | 03-11-2014 04:51 AM |
Windows 10 
Office 2019
Threaded Mode