Home

Pivot Table separating date field into year and quarter

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

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

image.png

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
21 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies