英文:
EXCEL Pivot Table not showing all the months
问题
我正在尝试制作一个数据透视表，但我无法理解可能出了什么问题。我想在行标签中显示所有的月份，但它只显示了一月份。（我正在使用Excel 2021。）
数据集链接：数据集链接
在这里，您可以看到它只显示了一月份。我的Excel截图显示了一月份
我在Google Sheets中尝试了一下，它完全正常，但我似乎无法理解为什么在我的Excel 2021中会出问题。
我期望的效果
英文:
I was trying to make a Pivot Table and I cannot understand what could be wrong. I want to display all the months in the Row Labels but it only displays the month of January. (I'm using Excel 2021.)
Link to the dataset: link to dataset
Here you can see, it only shows the month of January. Screenshot of my Excel showing the month of Jan
I tried in google sheets and it works perfectly fine but I can't seem to understand why is it a problem in my Excel 2021.
What I am expecting
答案1
得分: 3
很可能您的系统认为这些都是美国日期格式，所以01被视为一月而不是月份的第一天。
我将它们格式化为英国风格，数据透视表可以正常工作（除了那个奇怪的值）：
英文:
It's likely your system thinks these are all American format dates so 01 is being taken as January not the first of the month.
I formatted them as UK style and Pivot Table works fine (apart from that one odd value):-
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论