按照连接到SSAS OLAP多维数据集的Excel中的键进行排序

我搜索了Internet和*，无法找到此问题的答案。我通过带有日期维度的SSAS创建了一个OLAP多维数据集。维度的一个属性是活动日历月。 NameColumn 的格式格式如2015年1月，2015年2月等。

I searched the Internet and * and was not able to find an answer to this issue. I created an OLAP cube via SSAS with a date dimension. One of the attributes of the dimension is Activity Calendar Month. The NameColumn value is formatted like "January 2015", "February 2015", etc.

KeyColumns 设置为每月第一个月的DATE值类型。例如 NameColumn valueJanuary 2015= KeyColumns value1/1/2015，2015年2月= 2/1/2015等。

The KeyColumns is set as a DATE value type for the first of the month, for each month. Example, NameColumn value "January 2015" = KeyColumns value "1/1/2015", "February 2015" = "2/1/2015", etc.

ValueColumn 也设置为月初一（例如1/1/2015），以防Excel正在使用排序。

The ValueColumn is also set to first of the month date (i.e. '1/1/2015') in case Excel was using that for sorting.

当我查看Excel中的日历月份维度2013工作簿，它最初加载正确的排序。以下是一个示例：

When I view the Calendar Month dimension in an Excel 2013 workbook, it initially loads with the correct sorting. Below is a sample:

January 2015
February 2015
March 2015
April 2015
May 2015
June 2015
July 2015
August 2015
September 2015

但是，我希望能够在Excel中右键单击该字段，然后选择排序>排序Z到，然后排序月份。当我目前这样做的时候，我回来了：

However, I want to be able to right-click on the field in Excel and select Sort > Sort Z to A and sort the months descending. When I currently do this, I get back:

September 2015
May 2015
March 2015
June 2015
July 2015
January 2015
February 2015
August 2015
April 2015

对我来说，Excel只会根据维度的 NameColumn 中设置的字母数字值进行排序。此外，如果我从月份价值（即1月而不是2015年1月）下降年份，Excel似乎明白这是一个月，并正确排列这些月份。

To me, it appears the Excel will only sort based on the alphanumeric value set in the dimension's NameColumn. Also, if I drop the years from the month values (i.e. "January" instead of "January 2015"), Excel seems to understand that it is a month and sorts the months correctly.

• Excel有能力对 NameColumn $ c $之外的值进行排序c>，例如 KeyColumns 或 ValueColumn ，其中 NameColumn 不使用标准月份名称（即1月，2月等）？

• Does Excel have the capability to sort on values outside of NameColumn, such as KeyColumns or ValueColumn, where the NameColumn does not use standard month names (i.e. "January", "February", etc.)?

如果是，那么