Issue With Date In Pivot Table

p45cal · #1 01-18-2022, 08:23 AM

How to Group Dates in Pivot Tables in Excel (by Years, Months, Weeks)

Grouping Dates in a Pivot Table VERSUS Grouping Dates in the Source Data - Excel Campus

If your version of Excel allows you to add a timeline, you may not even need to group the dates at all; the timeline will do it for you - the dates don't even need to appear in the pivot table.
2022-01-18_151844.png

and:
2022-01-18_151701.png

tomohawk · #2 01-18-2022, 08:42 AM

Thanks p45cal

I realised that my base data had two formats for date, so when that was fixed, I was able to group

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Pivot Table Filter Issue	mikeinli	Excel	1	09-23-2020 01:26 PM
Pivot table dates issue	salse	Excel	1	06-08-2016 12:23 PM
Excel pivot table with a DATE value field for some reason stops at a certain date	angie450	Excel Programming	2	08-19-2014 08:50 AM
Pivot Table issue	ominae	Excel	1	07-18-2014 01:40 AM
Pivot Table Issue	Grovesy	Excel	0	10-28-2012 09:08 PM