如何根据 Excel 2010 数据透视表包含的数据子集对其进行排序？
我有一个 Excel 2010 数据透视表，其中包含类别和计数度量作为数据。这些类别下面有一个嵌套的日期维度，经过过滤后仅显示过去两个月。
当我对类别进行排序时，我会按照 6 月和 7 月的计数度量总计按降序对它们进行排序。
谁能建议我如何仅根据 6 月数据（而不是 6 月和 7 月的总计数据）对类别进行排序？
谢谢！
I have an Excel 2010 pivot table that has categories and a count measure as the data. Those categories then have a date dimension nested underneath, filtered to show only the last two months.
When I sort the categories, I am sorting them by the total of the count measure across both June and July, in descending order.
Can anyone suggest how I can sort the categories based on the June data alone, as opposed to the total for both June and July?
Thanks!
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
您的问题与 Sql Server Analysis Services 无关。 SSAS 提供多维数据，数据透视表也将其用作数据源。这就是您在这里看到数据透视表问题的原因。但它们与 Excel 无关。
不管怎样，我想尝试回答你的问题。据我了解您的问题，更改数据透视表中维度的顺序足以实现您的目标。首先将日期维度添加到数据透视表，然后添加类别维度，以获取按日期（月）分组的数据。然后，您可以按类别排序以获得您想要的结果。
希望这有帮助。
Your questions is not related to Sql Server Analysis Services. SSAS provides multidimensional data that is also used by pivot tables as datasource. So that's why you have seen pivot table questions here. But they are not Excel related.
Anyway, i want to try to answer your question. As far as i understand your question, changing the order of the dimensions in your pivot table will be sufficient to achieve your goal. Add the date dimension to the pivot table first and then the category dimension to get your data grouped by date (month). You may then sort by categories to get the result you want.
Hope this help.