Mar 29 2019
02:05 PM
- last edited on
Jul 12 2019
11:23 AM
by
TechCommunityAP
Mar 29 2019
02:05 PM
- last edited on
Jul 12 2019
11:23 AM
by
TechCommunityAP
Source date include several years of monthly date using first of month, ie 1/1/2012, 2/1/2012 ....12/12012,1/1/2013. When i put those dates in the column heading of my pivot table it sums the January values for all years, February values for all years etc.
Tried turning off auto subtotals but no help
Windows 7 Excel would return column headings a a series of first day of month for all years in the data.
That makes sense - I want to see a table with columns for all the calendar months with the sum of the value fields.
Mar 29 2019 02:37 PM
SolutionNewer version of Excel invoke automatic date grouping.
Right click in the pivot table and ungroup.
Mar 29 2019 02:37 PM
SolutionNewer version of Excel invoke automatic date grouping.
Right click in the pivot table and ungroup.