Forum Discussion

365notavfan's avatar
365notavfan
Copper Contributor
Mar 29, 2019
Solved

Windows 365 Excel Pivot table dates

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 Janua...
  • Detlef_Lewin's avatar
    Mar 29, 2019

    365notavfan 

    Newer version of Excel invoke automatic date grouping.

    Right click in the pivot table and ungroup.

     

Resources