SOLVED

grouped pivot table on year

Copper Contributor

when I grouped a pivot table in Excel it didn't work with dates/year older than 1900-01-01. Is there a way to bypass this restriction?

3 Replies
best response confirmed by Hans Vogelaar (MVP)
Solution

@Helge_Kjell 

Use helper columns in your data.

Or use a different spreadsheet software without this restriction.

 

@Detlef Lewin 

Thanks, it helped me out of the trouble :stareyes:

@Helge_Kjell 

Another workaround could be to load source into Power Query. It recognizes dates starting form year 100. In Power Query add Year and Month columns (or whichever you need) and load transformed table into the grid as PivotTable.

image.png

1 best response

Accepted Solutions
best response confirmed by Hans Vogelaar (MVP)
Solution

@Helge_Kjell 

Use helper columns in your data.

Or use a different spreadsheet software without this restriction.

 

View solution in original post