Thread: [Solved] Pivot Table Date Issue
View Single Post
 
Old 02-01-2022, 10:08 AM
p45cal's Avatar
p45cal p45cal is offline Windows 10 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