Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #6  
Old 01-18-2022, 08:23 AM
p45cal's Avatar
p45cal p45cal is offline Issue With Date In Pivot Table Windows 10 Issue With Date In Pivot Table Office 2019
Expert
 
Join Date: Apr 2014
Posts: 962
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default

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
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot Table Filter Issue mikeinli Excel 1 09-23-2020 01:26 PM
Issue With Date In Pivot Table 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
Issue With Date In Pivot Table Pivot Table issue ominae Excel 1 07-18-2014 01:40 AM
Pivot Table Issue Grovesy Excel 0 10-28-2012 09:08 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:41 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft