|
|
#1
02-01-2022, 03:04 AM
|
|||
|
|||
Pivot Table Date Issue
I have a spreadsheet with a data table from which I create a pivot table. In the columns section of the pivot table, I use the Date field and I want to only show Months. I am getting a very strange result in the columns (see attached). Also, when I use the column drop-down in the pivot table, I can see the strange selections as well as all 12 months. The data table ONLY contains data for January 2022. Tommy 
|
|
|
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 dates issue
|
salse | Excel | 1 | 06-08-2016 12:23 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 |
|
Pivot Table issue
|
ominae | Excel | 1 | 07-18-2014 01:40 AM |
| Pivot Table Issue | Grovesy | Excel | 0 | 10-28-2012 09:08 PM |
Windows 10 
Office 2019
Threaded Mode