Pivot Table Dates Timeline

[Lorraine N]

Hi, Relatively new to Pivot tables... I am trying to develop a pt report based on an exported datasheet from Access. The Date field in the database has been formatted to short date (9/26/2016). When I put the pt to work, all the dates show up on the column headers properly, but I cannot seem to group them on a timeline (by month/year). I get the error message that it doesn't have a field formatted as date - even though they are. Thanks for your help!

The goal is to see the data by MM/YY

 

[Lorraine N]

Well, no one helped me on this. But I eventually figured it out on my own.

 

[zrx1200]

Well, no one helped me on this. But I eventually figured it out on my own.

Hi, care to share your solution so others may benefit.

 

[Lorraine N]

Hi, care to share your solution so others may benefit.

Simply put, Excel doesn't like date fields that are exported from other sources, so I had to use Text to Column. Which still has bugs that I can't get around so I'll have to rework my goal.

 

[zrx1200]

Simply put, Excel doesn't like date fields that are exported from other sources, so I had to use Text to Column. Which still has bugs that I can't get around so I'll have to rework my goal.

Thanks for taking the time to share.