Pivot Table separating date field into year and quarter

%3CLINGO-SUB%20id%3D%22lingo-sub-309019%22%20slang%3D%22en-US%22%3EPivot%20Table%20separating%20date%20field%20into%20year%20and%20quarter%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-309019%22%20slang%3D%22en-US%22%3E%3CP%3Ewhen%20i%20create%20a%20pivot%20table%20and%20select%20the%20date%20field%2C%20it%20doesn't%20pull%20the%20data%20in%20as%20Dec%2012%2C%202018%2C%20etc.%20it%20pulls%20the%20data%20into%20the%20pivot%20as%20year%2C%20and%20quarter.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESee%20screenshot%20below.%20how%20do%20i%20fix%20this%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Efirst%20screen%20shot%20is%20how%20it's%20pulling%20the%20date%20field.%3C%2FP%3E%3CP%3Esecond%20screen%20shot%20is%20how%20i%20need%20and%20it%20should%20be%20pulling%20the%20date%20field%20data.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22excel_ss_01.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F64683i9CF346EB93FF0982%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22excel_ss_01.png%22%20alt%3D%22excel_ss_01.png%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22excel_ss_02.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F64682i6DBE8FA4349AC5D1%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22excel_ss_02.png%22%20alt%3D%22excel_ss_02.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-309019%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1882581%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20Table%20separating%20date%20field%20into%20year%20and%20quarter%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1882581%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F260468%22%20target%3D%22_blank%22%3E%40abrown520%3C%2FA%3E%26nbsp%3B%3CSPAN%3ETry%20right-clicking%20any%20of%20the%20date%20items%20(Year%2C%20Quarter%20or%20Date)%20and%20select%20Ungroup%20from%20the%20context%20menu.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-309067%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20Table%20separating%20date%20field%20into%20year%20and%20quarter%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-309067%22%20slang%3D%22en-US%22%3E%3CP%3EYou%20may%20remove%20Year%20and%20Quarter%20fields%20when%20created%20or%20in%20options%20disable%20that%20setting%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20565px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F64692iD6BB962B768B8E55%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
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

3 Replies

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

image.png

@abrown520 Try right-clicking any of the date items (Year, Quarter or Date) and select Ungroup from the context menu.

@abrown520 I have tried the options > data and disabling the auto grouping.  It did not help change the dates back to dates rather than Year, Quarter & Month.  I am not at all found of this MS enhancement.  I think it should be changed so that if you want it to auto group then you select.  Thank you for your guidance.  I thought it would work as your instructions were very clear.