Home

Pivot Tables!!!!!

%3CLINGO-SUB%20id%3D%22lingo-sub-862862%22%20slang%3D%22en-US%22%3EPivot%20Tables!!!!!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-862862%22%20slang%3D%22en-US%22%3E%3CP%3E%26nbsp%3BFinally%20discovering%20the%20world%20of%20Pivot%20Tables%20and%20it%20is%20Amazing!%20Feel%20like%20I%20might%20never%20need%20to%20use%20formulas%20again.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHaving%20some%20trouble%20grouping%20the%20dates%20in%20my%20pivot%20table%20I%20created%20for%20transactions%20over%20the%20last%2012%20months.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20help%20will%20be%20appreciated!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-862862%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ENeed%20Help%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-863374%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20Tables!!!!!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-863374%22%20slang%3D%22en-US%22%3ECan%20you%20share%20an%20example%20of%20your%20problem%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-863521%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20Tables!!!!!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-863521%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F411708%22%20target%3D%22_blank%22%3E%40jacovdl%3C%2FA%3E%26nbsp%3B%20Without%20an%20example%2C%20my%20first%20thought%20is%20date%20formatting%3B%20make%20sure%20the%20data%20column%20is%20properly%20formatted%20as%20date%20(Data%2C%20Text%20to%20Columns)%20%26amp%3B%20the%20date%20format%20(format%20cells)%20is%20correct.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-866696%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20Tables!!!!!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-866696%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%2C%20please%20see%20attached%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-866698%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20Tables!!!!!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-866698%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F50479%22%20target%3D%22_blank%22%3E%40Rusty%20Dane%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20tried%20to%20format%20the%20date%20columns%20numerous%20times%2C%20but%20it%20doesn't%20seem%20to%20work.%3C%2FP%3E%3CP%3EPlease%20get%20the%20data%20file%20attached%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-867519%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20Tables!!!!!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-867519%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F411708%22%20target%3D%22_blank%22%3E%40jacovdl%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESelect%20column%20B%2C%20Data-%26gt%3BText%20To%20Columns%20and%20on%20third%20step%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20301px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F132789i9CFD9718BB7F8777%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EResult%20is%20attached.%3C%2FP%3E%3C%2FLINGO-BODY%3E
jacovdl
Occasional Contributor

 Finally discovering the world of Pivot Tables and it is Amazing! Feel like I might never need to use formulas again.

 

Having some trouble grouping the dates in my pivot table I created for transactions over the last 12 months.

 

Any help will be appreciated!

 

Cheers

5 Replies
Can you share an example of your problem?

@jacovdl  Without an example, my first thought is date formatting; make sure the data column is properly formatted as date (Data, Text to Columns) & the date format (format cells) is correct.

Thanks, please see attached

Hi @Rusty Dane 

 

I've tried to format the date columns numerous times, but it doesn't seem to work.

Please get the data file attached

@jacovdl 

Select column B, Data->Text To Columns and on third step

image.png

Result is attached.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 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
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies