Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #4  
Old 02-01-2022, 10:08 AM
p45cal's Avatar
p45cal p45cal is offline Pivot Table Date Issue Windows 10 Pivot Table Date Issue Office 2019
Expert
 
Join Date: Apr 2014
Posts: 956
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

I suspect that when you grouop ther dates by Months, you do get all the months in the dropdown.
Separately, if you only group my Months (as opposed to groupiong by Month and Years) then if your source data extends over more than one year, all the the data from multiple years will appear under a single month name.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot Table Date Issue Issue With Date In Pivot Table tomohawk Excel 6 01-18-2022 08:42 AM
Pivot Table Date Issue 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 Date Issue 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 11:35 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