Home

Pivot Table separating date field into year and quarter

Highlighted
abrown520
Occasional Visitor

when i create a pivot table and select the date field, it doesn't pull the data in as Dec 12, 2018, etc. it pulls the data into the pivot as year, and quarter. 

 

See screenshot below. how do i fix this? 

 

first screen shot is how it's pulling the date field.

second screen shot is how i need and it should be pulling the date field data.

 

excel_ss_01.pngexcel_ss_02.png

1 Reply
Highlighted

You may remove Year and Quarter fields when created or in options disable that setting

image.png

Related Conversations
Date format in Stream
Dave Pyett in Microsoft Stream Forum on
3 Replies
Counting Days
Tim Hunter in SQL Server on
2 Replies
PivotTable : Unexpected behavior with 2 tables
CastyChichi in Excel on
2 Replies
Set Auto Refresh to Pivot Table as Source Data Changes
ratishkp in Excel on
2 Replies