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.

Highlighted

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
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies