In Excel 2016, pivot tables handle dates and times differently and it's driving me crazy. Every time I pull dates or times into a pivot table, Excel automatically creates new fields that bucket my data. For example, if I try to do a simple count of interactions during 15-minute intervals, it does this:
Pivot.PNG
This results in lost data, because it isn't giving me the count for the intervals that fall on hour. With dates it's even worse. It buckets the date into years and months automatically, when all I want is a list of dates and their corresponding count. Does anyone know how to turn this off? I've looked everywhere and I can't find anything about it.
Bookmarks